I made shortcuts that basically do the same as File/Open and that works. Will
have to look into why it doesnt work the other way after our events. Its
getting close to crunch time.
Thanks guys
----- Original Message -----
From: James Kerr
To: NT System Admin Issues
Sent: Friday, November 21, 2008 4:25 PM
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
To: NT System Admin Issues
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
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/> ~
