Dear Jerry,
Thanks for your answer. Its much appreciated.
Jerry Whittle said:
The version should not matter as Access 2003 can work with the Access 2000
file format.
I realise that as I used the 2000 version in Access 2003 without converting
it for a long time, maybe 2 years. Maybe that is the problem though, when
copied it locks.
How did you make the backups? If you use Windows Explorer to copy the file
while the database was in use, that might cause problems; however, I've do it
often. If you used Tools, Database Utilities, Back Up Database, that should
have worked OK. It's possible that it created corrupted database files
especially if your working database had problems. (Hint: Making a backup is
not the same thing as making a backup then testing it).
I realise now that I should have tested all of my copies.. I used Nero to
make a data disk (both dvd and cd) and burned it on the disk. I then assumed
it was a working copy. Not once did I test it in 2 years. The database was
always closed. The sad thing is I did this every couple of months and going
back for 2 years I get the same message when I try to access any of those
copies of the file now. Even .bak files open with the same error message.
Strangely the database was working right up to when I took the last copy.
Then it was formatted over and I have lost the working copy of last Thursday.
Was the database secured with user-level security? If so you also need a
copy of the workgroup .mdw file.
No it had no user-level security involved. There's only me that uses it.
Does the error message talk about a system table (like MSys)? If so it is
corrupt. Have you tried a compact and repair?
No it doesn't talk about a system table . It always refers to what ever
file is highlighted when in the database.
If I am in Tables and have Members table highlighted the error message is
"Could not read definitions:no read definitions permission for table or query
members"
Strangely it lets me do a compact and repair but afterwards the error
message is on everything still and won't let me access.
For more info on corruption:
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm
I have been into this article but haven't so far tried the fixes.
Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html
Allen Brown's article looks promising. Thanks.
I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
Wow, looks like a lot of advice. Thanks for your help. I will away to
find out what might help. I have also got a Nero backitup version from last
December, I might try and restore that one first.
Its just so weird.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
bendigobarb said:
I have been using a database in Office Pro 2003 but it's read the database
when converted from Office Pro 2000 and kept it as a Access 2000 file
format. It didn't convert it to 2003. I never noticed this and kept putting
copies of this database on disks for backup but because the original database
never failed me I didn't realise the copies weren't openable. Now I have
reformatted my hard drive destroying the operating version, even though I
very carefully kept copies of this database thinking I was safe. Now on
opening the copy of the database I get the error message for everything I
try to open (Records cannot be read: no read permission on [name of
table/query/form] I am assuming the copy is corrupt. The db is 78,528 kb in
size. it all appears to be there it just won't open. Is there any hope of
retrieving anything. I can't believe this has happened. !!
BB
