Can anyone tell me what's a best guide in determining as to whether to use the built-in Access database or using Microsoft SQL Server in developing an database application?
Printable View
Can anyone tell me what's a best guide in determining as to whether to use the built-in Access database or using Microsoft SQL Server in developing an database application?
If you are developing a application in MSAccess, you can use the built in Access database to make it easier on yourself. Then if you feel the need to upgrade to SQLServer later on you can use linked tables. This means you won't have to change a single piece of code.
As for why you would use one as opposed to the other:
SQL Server can handle loads of users a lot better, it can handle a lot more data (1-2GB in Access - more or less unlimited in SQLServer), and it is quicker. On the other hand it is expensive, harder to program, manage, and administer. SQLServer is also (to the best of my knowledge) not suitable for desktop computing. It is best used where a server is available.
There is also the new kid on the block. The desktop version of SQL server. Take a look here.
http://msdn.microsoft.com/vstudio/msde/default.asp
I just downloaded it myself so I don't know anything about it yet, but I thought I would let you know.
Best,