Upsize Access database?
March 10, 2009 1:39 PM Subscribe
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head?
posted by cbrody to Technology (11 answers total) 7 users marked this as a favorite
To give an idea as to the size of the project the current system has 35 tables, and on the order of 1000 queries and 1500 macros defined. Not even the original developer (the client) knows which ones are actually in use. There are on the order of 200,000 records in the current live system. The client is not willing to spend the money to have the system completely re-built (which I would estimate at being at 3-6 months’ work) but they would like some input as to how the current system could be improved, and they are probably willing to spend enough to cover two to three weeks of my time.
I have done some tests, successfully upsizing the tables to MySQL, but even a single insert from one of the simpler entry forms fails. I figure that with my basic knowledge of SQL that I could probably get a lot of it working (if not very efficiently), but would MS SQL be a better bet for compatibility and performance issues? I have a fair amount of experience with Access, having built customer management and billing systems from scratch, but am no SQL/RDBMS guru. I could use this work, but am I doomed to fail?