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
Thread Forum
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...
Software
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 23:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App