Link to home
Start Free TrialLog in
Avatar of pinkstonm
pinkstonm

asked on

Problem with an access DB won't open

I updated a field in an access db and saved now it will not longer open HELP.


I am getting this error

Record(s) cannot be read; no read permission on <name>. (Error 3112)
You must have read permission for the specified table or query to view its data. To change your permission assignments, see your system administrator or the table or query's creator.
Avatar of pinkstonm
pinkstonm

ASKER

Initial error said something about me or another user may have quit acess while file was open or something?
THis is a very important DB and I need to recover
can you create a completely new (and empty) MDB, and then copy the tabels etc from the broken MDB to the new one?

AW
I can not open the old one? i keep getting errors
When I try to open with ASP I get

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'registration'.

/youth/admin/inc_usercheck.asp, line 10
Avatar of Benjamin Lu
Are you the Admin of this DB?
Is it working fine before?
Have you set the security?

Best Regards

Ben
Yes it is my DB and yes I had it open 10 minutes ago
are there anytoold available to fix the DB?
Can you open this DB directly not from ASP code ?

Best Regards

Ben
Hello,
Close your DB and go to the directory that DB is saved in it. Change your Windows Explorer settings to view hidden and system files. Delete file with name as same as your DB and extension LDB (Your DB has MDB extension)
Open your DB and check Permissions in

Tools > Security > User and Group Permissions

Also check that if you can create a asmple text file in your directory that DB is saved.

-FA
I did that and there was no LDB file there...
The DB is in a frontpage web but I have copied it to my hard drive as well.
Can you open and edit your DB now after copy to your hard drive?

Best Regards

Ben
no :(

thats when I get the error that says

records(s) can not be read, no permissions on 'MySYSAccessObjects'.

Record(s) cannot be read; no read permission on <name>. (Error 3112)
You must have read permission for the specified table or query to view its data. To change your permission assignments, see your system administrator or the table or query's creator

Is it possible that the file was marked as read-only somehow? You may check this by right-clicking on the file and choosing properties. If the read-only box is checked, clear it and click OK.

Also, you may want to try compacting and repairing your db. I know that you cannot directly access it by, say, double-clicking on it. But, what you may be able to do is open Access, clicking on the Tools menu, open the Database Utilities submenu and then choosing Compact and Repair Database. A file browser window will open. Point it to the file and then click the Compact button.

These may be shots in the dark, but give them a try and see what happens.

Good luck.
ASKER CERTIFIED SOLUTION
Avatar of stevbe
stevbe

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial