Dear Jerry,
Thanks for your answer. Its much appreciated.
"Jerry Whittle" wrote:
> 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" wrote:
>
> > 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
Similar Threads
