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 Kerr To: NT System Admin 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/> ~
