|20 Oct 2010||#1|
Database - MS Access Backend vs MS SQL
i would like to ask for database performance :
currently i split my ms access database to front end (form interface) and backend. the backend file i put on shared folder on dedicated pc, which i assume as server. the database then access by 10 staff, which having the frontend file on each pc. the backend file was ~20MB in size.
there's an option, which is upsizing the backend to be sql. then install ms sql server express 2008 r2 on "server" pc, then host the backend file and modified the frontend file so, it'll access the backend database on sql connection.
is this will increase any performance from current setting?
|My System Specs|
|20 Oct 2010||#2|
probably not the answer you are looking for but if you use MySQL (FREE for non commercial users) you will improve your DB performance compared with MS ACCESS by literally ZILLIONS of percent.
It's slightly more complex to get up and running but there are tutorials all over the web.
Beats running a "cut down version" of ms sql too.
Incidentally MySQL in combination with Apache, and PHP makes a great WEB server too (WAMP). Also compatable with Linux where the same combination is called LAMP.
|My System Specs|
|Similar help and support threads for2: Database - MS Access Backend vs MS SQL|
|Access Database Question||Microsoft Office|
|Any problems using Access 2007 database with Access 2010?||Microsoft Office|
|Sharing an Access Database||Network & Sharing|
|Access 2010 database password removal||Microsoft Office|
|Create a Database with all my Music - MS Access||Microsoft Office|
|Problem saving an old access database||Microsoft Office|
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
All times are GMT -5. The time now is 06:34 PM.