Database - MS Access Backend vs MS SQL


  1. erry3k
    Posts : 5
    Win 7 x86
       New #1

    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 Computer
    Quote Quote

  3. jimbo45
    Posts : 5,941
    Linux CENTOS 7 / various Windows OS'es and servers
       New #2

    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.

    Cheers
    jimbo
      My Computer
    Quote Quote

 

  Related Discussions
Hi friends, I have some Compiled VB6 projects installed on my Windows 7 laptop. (Mostly copies of Software supplied to the clients) They would be working fine, then all of a sudden, may be after weeks, or months, I get an error when launching the software 'Unrecognized database format' On checking...
Access Database Question
in Microsoft Office

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....
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...
Sharing an Access Database
in Network & Sharing

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...
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
Our Sites
Site Links
About 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 16:04.
Find Us