Dear experts,
I am currently using Microsoft Access and the current size of my database is about 250Mb. I need to incorporate an additional set of data which could potentially double the size of the database or more. I am considering whether to switch to a more professional database manager like SQL. I have the following questions:
1. How much data can Access realistically handle before performance starts to degrade materially?
2. What is the next best option for database upgrade in Windows environment (SQL server, etc)?
3. I am currently accessing my database via VBA (ActiveX Data Objects) within Excel application. If I switch to SQL, would I need to rewrite my code?
4. How difficult is it to convert the database from Access to SQL server format?
Thanks for your help. Any additional insights on pros and cons of Access vs. converting to SQL server would be greatly appreciated.
CWF
For a quick MS response: http://www.microsoft.com/sql/solutions/ssm/access/compare-access.mspx
Other than that, i did a quick msn search for "access versus sql server" and found many articles. Look through them and post any other questions you have here.
|||Thanks. This is very helpful.
No comments:
Post a Comment