Access keeps saying someone else has the file open

[luckycharms]

Hi Folks,



I've been getting some database imports and VBA code running on Access 2007 (and Win 7 Pro x64). But now, more often than not, after running some code that errors out, when I make changes in the VB Editor and try to save them, Access give me an error. It tells me that another user has the file open (though there are no other users using it, of course).

This is horribly annoying - i have to keep closing and re-opening the database. Any ideas as to what's going on here? Any help greatly appreciated!

Thanks,
Allie

[ajetrumpet]

it tells you this only after you run the code and error it out? if so, what is the code and what is the line that it errors on?

what do you do after it errors? end it from the dialog popup?

[luckycharms]

seems to be the case that after the code errors out this happens. there's a bunch of code, doesn't always happen on the same line. can't remember if it only happens when the code errors out though.

when it errors out, i either debug and then stop, or just end it there.

[ajetrumpet]

seems to be the case that after the code errors out this happens. there's a bunch of code, doesn't always happen on the same line. can't remember if it only happens when the code errors out though.

when it errors out, i either debug and then stop, or just end it there.

what I'm trying to get at is that the message could be generated from an open object in the code that is not closed and de-referenced due to stopping the procedure in the middle. I don't think this is likely, but I've run into similar issues in the past...

If you post the code, it might become more evident whether it is playing an issue in this problem or not. By the way, I love your cereal...

[NTC]

look in the folder where the .mdb is being held ; when the app is closed - and see if there is still a .ldb file there...if so - right click and delete it.

otherwise do a compact/repair.

hope this does the job.