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: Sharing an Access Database

27 Apr 2011   #1
Garfonzo

Ubuntu 10.0.4
 
 
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 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?

Any ideas?

Thanks!


My System SpecsSystem Spec
28 Apr 2011   #2
Garfonzo

Ubuntu 10.0.4
 
 

No one has any ideas?
My System SpecsSystem Spec
Reply

 Sharing an Access Database




Thread Tools



Similar help and support threads for2: Sharing an Access Database
Thread Forum
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

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 02:57 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App