|27 Apr 2011||#1|
Sharing an Access Database
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 those in the LAN.
By default, MS Access is set up to allow more than one user access (read/write) the database. However, for some reason, we cannot achieve this in our office. Once one person has the database open, the second person can double click on the database icon, there is a flicker (as if the application opens and instantly closes) and that's it. No sharing.
The strange thing is that if someone on the LAN has the database open, a user physically at the server can open up the database, thereby allowing more than one user. The key is that of the two people accessing the database, one of them must be accessing it from the server itself. This is obviously sub-optimal.
Is this is a Windows 7 issue, or something relating to MS Access?
|My System Specs|
|Similar help and support threads for2: Sharing an Access Database|
|Access Database Question||Microsoft Office|
|Network performance issues, 4 computers sharing an access database||Network & Sharing|
|Any problems using Access 2007 database with Access 2010?||Microsoft Office|
|Database - MS Access Backend vs MS SQL||Software|
|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 02:57 AM.