Record(s) cannot be read; no read permission on 'MSysAccessStorage

J

Jahanzaib

Hi,

I have a database with security.mdw, all was OK and databases is being used
by 6 users for past few months, problem starts when suddenly I get this error
while opening the database.

Record(s) cannot be read; no read permission on 'MSysAccessStorage'.

I tried these things but no solution:

Pressing Shift Key :> an error mesage shows that LogIn (created by me) form
is mispelled.
Trying to import tables using odbc with access db, excel and MS Sql
Enterprise manager :> acccess tells me you cannot import exports using ODBC,
excel returns 'unable to obtain table list, while ms sql cannot execute
'openrowset'.

The databse has very important information, and I am in a big trouble,
please help to solve this.

Regards,
 
T

Tony Toews [MVP]

Jahanzaib said:
I have a database with security.mdw, all was OK and databases is being used
by 6 users for past few months, problem starts when suddenly I get this error
while opening the database.

Record(s) cannot be read; no read permission on 'MSysAccessStorage'.

I tried these things but no solution:

There are a few more things to try at the Microsoft Access Corruption
FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm

TOny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top