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

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?


My System SpecsSystem Spec
28 Apr 2011   #2

Ubuntu 10.0.4

No one has any ideas?
My System SpecsSystem Spec

 Sharing an Access Database

Thread Tools

Similar help and support threads
Thread Forum
Tables disappear from my MS Access database
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...
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
Network performance issues, 4 computers sharing an access database
Hey all please help.....I am working on machines at a local car lot heres the system details. Verizon DSL wireless router, don't know the exact model but all 4 computers are hard wired to it with newer cat5e. 4 newer desktop computers, within months. all 4 same specs. They are HP systems with...
Network & Sharing
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
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...

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 10:25.
Twitter Facebook Google+