[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 734
  • Last Modified:

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.
0
pinkstonm
Asked:
pinkstonm
1 Solution
 
pinkstonmAuthor Commented:
Initial error said something about me or another user may have quit acess while file was open or something?
0
 
pinkstonmAuthor Commented:
THis is a very important DB and I need to recover
0
 
Arthur_WoodCommented:
can you create a completely new (and empty) MDB, and then copy the tabels etc from the broken MDB to the new one?

AW
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
pinkstonmAuthor Commented:
I can not open the old one? i keep getting errors
0
 
pinkstonmAuthor Commented:
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
0
 
Benjamin_LukCommented:
Are you the Admin of this DB?
Is it working fine before?
Have you set the security?

Best Regards

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

Best Regards

Ben
0
 
Farzad AkbarnejadDeveloperCommented:
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
0
 
pinkstonmAuthor Commented:
I did that and there was no LDB file there...
0
 
pinkstonmAuthor Commented:
The DB is in a frontpage web but I have copied it to my hard drive as well.
0
 
Benjamin_LukCommented:
Can you open and edit your DB now after copy to your hard drive?

Best Regards

Ben
0
 
pinkstonmAuthor Commented:
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
0
 
Painfree888Commented:

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.
0
 
stevbeCommented:
MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool:
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 
http://www.access-emergency.com/
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now