I've read through many posts here looking for an answer and can't seem to find one that really addresses my particular
problem. I've had experience with the exclusive access numerous times before, so am aware of the "typical" problems and
fixes. This one has me stumped, though.
I have a db that is on a network drive. Workgroup security is set up on it with only the administrator (me) set to
"exclusive access" under the permissions. I have a blanket read-only user logon that most of the others in my office use.
I thought at first this problem only arose when others but me opened it, but it seems to come and go.
Basically, I get the "you do not have exclusive access to the database at this time, if you proceed any changes you make may
not be saved" error message whenever anyone logs into the database FROM ONE PARTICULAR COMPUTER ONLY. The message appears
and you can click OK, then it reappears about a dozen or so times. Finally, it lets you use the database, and can make data
changes, etc. but no design changes. Another thing is this happens no matter if another user has the db open or not. There
is no ldb file in the directory when the database has been closed, but it does appear as it's supposed to when it opens.
I've checked the workgroup file, and it's fine, I tried opening it from the main file and from the desktop shortcut, I also
tried opening Access first then finding the file and using the "Open/Open Exclusive" drop down menu from the file browsing
window, and that seems to help; if I select "Open" it opens with out the error message. If I select "Open Exclusive" it
tells me I don't have permissions to open exclusively (this is using the read-only login), but proceeds to let me "open" the
database without the other error message that appears a bunch of times.
One other thing, I thought it was the computer and/or that maybe the program (Access) had gotten corrupted somehow, so the IT
guys replaced the computer and reinstalled Office 2000, and it's still doing it. Again, like I said, this is only happening
on one computer, which has been changed out even...
I'm totally at a loss here so any thoughts on troubleshooting this or remedying this would really be appreciated.
Thanks in advance!