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

18 Jun 2009 8:12 AM

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,

18 Jun 2009 11:31 PM

Tony Toews [MVP]

Jahanzaib <Jahanz***@discussions.microsoft.com> wrote:

>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

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/