Workgroup mode is a feature of MS Access. You don't say what version you are using, but for Access 2007, here are a couple of KB articles that explain how it works: http://support.microsoft.com/kb/305542 http://support.microsoft.com/kb/918583
...Tim From: James Kerr [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2008 1:25 PM To: NT System Admin Issues Subject: Re: Quick MS Access Question I dont know what workgroup mode might be but they are setup as a windows workgroup. I found out something more though. If I open the database using File/Open it works fine it just wont work if you click on the file itself or create a shortcut to the file which I find odd. I dont know, maybe its to have to be like that this year. ----- Original Message ----- From: Tim Evans<mailto:[EMAIL PROTECTED]> To: NT System Admin Issues<mailto:[email protected]> Sent: Friday, November 21, 2008 4:00 PM Subject: RE: Quick MS Access Question It's been a long time since I dealt with this (Access 98?), but I believe you need to enable workgroup mode on the notebook that is hosting the database. Even though the file is not opened exclusive, Access writes to a LDB lock file that other instances will respect. ...Tim 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 Kerr<mailto:[EMAIL PROTECTED]> To: NT System Admin Issues<mailto:[email protected]> 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/> ~
