Just a simple question here. I am curious if its best to use SQL for databases or can I use Access (.mdb files) databases
I'm very new to 2005 btw. And porting from vb6.
Thanks in advance.
VB2005 and MS Access
Hot Topic
- CUSTOM tooltips in VB.NET (bold, italic ...)
- Access or SQL Which one is better
- Windows Forms Problem
- Announcement: Article on Refactoring of legacy VB code.
- vb.net console app loads uxtheme.dll
- How would I update a whole ACCESS database???
- Adding expandable Container/Panel Control like on 'My Computer' Form
- 1 context menu for several controls
- ADO/Access Questions
- Playing a sound file
Visual Basic
- Add New Data Source for My SQL doesn't work
- trying to understand classes, module, subs, functions
- Treeview parent sort
- Splash Screen and Message Box
- What's the limitation of VB Express?
- AnalogTVTuningSpace and MSVidCtl
- GUID
- Problem with Socket?
- How to use SmtpNetworkElement for smtp authentication
- WebPage Interaction
VB2005 and MS Access
VASUSIVA
Hi
It really depends on the complexity and number of users that will be using your program concurrently. If you have a large user base then Access is definitely not the way to go whereas if you only have one or two users and want an easy way of deploying the database with the application then Access would suit nicely. SQL Server on the other hand will handle a large number of concurrent users and will allow for scalability at a later time.
You might also consider using SQL Server Express which is a lightweight version of SQL Server and can be deployed in the same manner as deploying Access databases. This will give you the added benefit of moving to an SQL Server database at a later time if the need arises without having to change much production code (if any at all).
HTH
James Inman
Hi
In terms of use, you will probably find Access easier, however I would have to say that if you are in any way serious about database programming then you will have to eventually learn SQL, so you may as well start now. You might find this quick tutorial on SQL of benefit before studying it further. w3Schools.Com - Learn SQL
SQL Server Express doesn't come with a user interface (at least to my knowledge) but you can add a new SQL Server Express database file to your server explorer and use the VS tools to create and modify your tables and create Views (queries) and stored procedures etc.
HTH
Derek0415
very nice. Thank you for the replies. I am mainly wanting Access because its so easy to use. With SQL express will I have to know the whole SQL Language as well I messed with SQL a while back when I was messing with PHP and it was just a headache like crazy.
So I just need to know if SQL Express needs the whole language commands, or is it just point and click like Access
Thanks again for the help. :)
wdcdba
SQL is robust, stable and fast... Access is somewhat stable and somewhat fast in comparison. But I've found backing up and editing Access databases much easier. Just copy the file and you're on your way.
So I guess it really depends on the amount of data and the number of users... if you're going for a crowd and a big database, try SQL Server. Or just try the SQL Server Express as its also a great alternative.
V Williams
Also consider security...
we used to have Access but it was far too easy to just copy the files and run off with the entire company database... with sql, we have it in a managed environment which just feels much more secure.