Corrupt mdb??

[Tyler]

When I try to compact a our application database I get an error
message as
follows: "Record(s) can't be read; no read permission on
'<<filepath\filename.mdb>>'


The compact process is terminated and Access leaves a db1.mdb file on
the
disk.


I have also created a new mdb-file and tried to import all object from
the
old one. Then I get the message " 'Index1' isn't an index in this
table.
Look in the Indexes collection of the TableDef object to determine the
valid
index names." When I click Ok I get a GPF and Access shuts down. This
message appears unregarded the type of object I try to import.

 

[Alan]

When I try to compact a our application database I get an error
message as
follows: "Record(s) can't be read; no read permission on
'<<filepath\filename.mdb>>'

The compact process is terminated and Access leaves a db1.mdb file on
the
disk.

I have also created a new mdb-file and tried to import all object from
the
old one. Then I get the message " 'Index1' isn't an index in this
table.
Look in the Indexes collection of the TableDef object to determine the
valid
index names." When I click Ok I get a GPF and Access shuts down. This
message appears unregarded the type of object I try to import.

Hi,

I think you can try a utility called Advanced Access Repair to repair
your Access MDB file. It works rather well for my corrupt Access MDB
files. Its web address is http://www.datanumen.com/aar/

Alan

 

[NetworkTrade]

is that mdb on a server or otherwise not on your desktop?

consider moving the mdb to your c: and then employing the compact and see
what happens...

 

[Tony Toews [MVP]]

I think you can try a utility called Advanced Access Repair to repair
your Access MDB file. It works rather well for my corrupt Access MDB
files. Its web address is http://www.datanumen.com/aar/

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/