MS Jet DB Engine Error Messages that make no sense

[Ally72]

I have a problem with a database I wrote that sits on the network and can be accessed by more than one user. I’ve set “Edited Record” record locking and it’s in Acc ’97.

When I try running a macro, I get the error message:

“The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.” …

but there is no-one else in the database.

When I try to copy and paste a table I get the same message. I have repaired the database, but when I try to compact, the following message comes up:

“Record(s) can’t be read; no read permission on ‘F:\ … … … name.mdb’”

but, there is no User Level security of any description. I am completely stumped . Can anyone please help!!?

 

[jfischer]

This sounds like a network permissions problem. Check with your network administrator to make sure that users have the right to Add/Create/Make/Change (whatever terms are appropriate for your network) files in the same directory as your database. Access may be having problems building its .LDB file that controls record locking due to the network permissions.

 

[Ally72]

Have just sorted out what the problem was. Apparently there was some corrupt data - not sure how it got there, but was showing as #Error#. I had to delete that record and the one after it, and re-enter.

Thank you anyway for your comment.