Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Database - MS Access Backend vs MS SQL

20 Oct 2010   #1

Win 7 x86
Database - MS Access Backend vs MS SQL

hi all,
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?

thank you.

My System SpecsSystem Spec

20 Oct 2010   #2

Linux CENTOS 7 / various Windows OS'es and servers

Hi there
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 SpecsSystem Spec

 Database - MS Access Backend vs MS SQL

Thread Tools

Similar help and support threads
Thread Forum
Access 2010 database password removal
Hi can someone please help me to remove a password i have set on my access 2010 database. I know the password but i am unable to find a way to remove it, i have done a search on the microsoft web site and i have got the followinf info. Remove a password Open the database in Exclusive...
Microsoft Office
Access Database Question
I've been tasked to set up an Access Database that will accept input from Excel spreadsheets (from a template file that is created and distributed to several employees. The files will contain about 25 fields, some inventory and some dollar amounts, as well as a few contact information type fields....
Microsoft Office
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
Sharing an Access Database
Hi Folks: I have a desktop running Win 7 Pro and acting as a file server in an office. There are 4 other Windows 7 computers in the office all with a mapped network drive from the server. We have an MS Access Database which "lives" on the server's hard drive and, therefore, is accessible to all...
Network & Sharing
Create a Database with all my Music - MS Access
Hey peeps, Got a bit of a project i want to do, I want to make a database in access that can do either of the following Talk to Media Player and copy all album and song information Or talk to Itunes and copy all album and song information
Microsoft Office
Problem saving an old access database
Mum has asked me to print off an old access database. I tried access 2007 but it refused to open it citing security concerns and other reasons. So I then tried Access 2002 in XP Mode but save as is greyed out and export to says it cant find the path.
Microsoft Office

Our Sites

Site Links

About Us

Find Us

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 17:14.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App