cant open back end?

  • Thread starter Thread starter JamesSF
  • Start date Start date
J

JamesSF

I have a back end file that wont let me open it - even with shift

all it says is

the microsoft jet database engine stopped the process because you and
another user are atempting to change the same data at the same time.

i have seen this before with updates to tables, but not on opening a
database back end.

new to me - any ideas?

thanks
JamesSF
 
Firstly, make sure no one (including you) is in the database.
Examine the folder where the back end mdb resides.
If there is an LDB file there with the same name, delete the LDB: it
contains locking information, and if no one is using the file it it spurious
(probably left over from a crash when Access did not get to clean up).

If that does not solve the problem, and there is no recordset, table, query,
form, or report open in the back end, and you have exclusive access, then
the message indicates a corruption. To get Access to rebuild it, follow the
steps for the first symptom in this article:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top