I've seen this behavior in Access files we use. I suspect in your case it's related to the "Everyone-Full Control" permission. We have several Access apps, but on ours, write permission (which appears to apply only to design) is limited to our group. If we open the app (with write permission), other users who try to open it while we're in it get an error message. Once we get out, they have no trouble accessing it. The security is set the same way you describe regarding sharing and record locking. Jim von Stein Information Services Administrator SOASTC
_____ From: James Kerr [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2008 12:54 PM To: NT System Admin Issues Subject: Re: Quick MS Access Question Basically we can only open the database on one PC at a time. The database is set to "shared" and set to "no locks" and "open databases using record level locking". There is nothing setup in security in security for the database. The share has full control for "everyone" and doesn't inherit permissions. The weird thing is that we use this file once a year, we clear it out every year of its data, rename it and its all good. I tried grabbing an older version of the file from a few years back and I have the same problem. Of course this is now a high priority and I will be working on this through the weekend because its needed for our biggest fundraiser. :-\ James ----- Original Message ----- From: James <mailto:[EMAIL PROTECTED]> Kerr To: NT System Admin <mailto:[email protected]> Issues Sent: Friday, November 21, 2008 2:09 PM Subject: Quick MS Access Question I have 4 notebooks. One has a share and in that share is a MS access file. The notebooks can open the database fine but not if the note with the database has it opened first. The file isnt getting opened exclusivly. Any ideas? James ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
