MS Access vs MS SQL Server
Posted on 2002-04-23
Does anyone have a URL to a comparison chart between Access and SQL Server. I have a client who is trying to determine which database to use with a VB front end. The database would house approximately 500 MB worth of data. And, it would be accessed by one client machine initially, but may be used by two are three machines in the future.
The main concern is execution time of queries. The queries would perform mathematical calculations on the data and return an answer to the screen. No fancy GUI.
I'm trying to provide him with a comparison between the two databases: cost, ease of use, ability to manipulate up to 1 GB of data, speed of execution, etc. Any feedback would be greatly appreciated.