• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

Access database won't open when others have it open

We have an Access 2000 database that 2 computers were sharing.  The host (PC1) computer has Access 2003 installed and PC2 has Access 2000 on it.  PC1 shares the database folder and PC2 maps a drive to the folder.  It has worked well until now.

All computers on the network are Windows XP.

We recently added a 3rd computer (PC3) to our network.  It has Access 2007 and can open the database, but only when no one else has it open.   PC3 can't open the database when it is in use if the file is doubleclicked directly.  PC3 CAN open the database when it is locked if the file is opened manually from the file menu.

I have checked to make sure that all computers are opening in Shared mode and not Exclusive mode in the Options.  A lock file does appear when a computer has the DB open.  

I think I am having a similar problem as this question, but don't have any Access expertise.  
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22101121.html

I should also say that this same problem also happened to PC2 when PC1 had to be reformatted, reinstalled and restored.  Is there a setting on PC1 that we have wrong?

Thanks,
 Ben
0
benab
Asked:
benab
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm assuming that you haven't split the database; if not, then you should do so (Access includes a splitter wizard). The wizard will produce a FrontEnd (forms, queries, reports, modules) and a Backend(tables only). You would then deploy a FE to each computer; each of those FE's should then connect to the SAME backend. Yes, this does make FE updates a bit more difficult, but that's the price ya pay for a multi-user app <g>.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note also that a lockfile will always appear when the db is open, regardless of what mode the db is opened with.

Also, make sure that ALL users have full permissions on the folder hosting the database file (all users must be able to read/write/create/destroy files in that folder, since they all must be able to manipulate the lockfile).

Note also that you may need to add that folder to the 2007 machine's "Trusted Zone". This is done in Access ... click the Options item, then examine the Trusted Zones section.
0
 
benabAuthor Commented:
Great.  I will try that next time I go there.  

Thanks much.  I didn't know about the splitter.   I thought about the concept that the user on PC3 might not have access to the lock file, but they should have the same security as the others.  I will check that too.

-Ben
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now