Hi all
I have been given a corrupt access 2000 backend and asked to salvage the
data.(youve gussed it, no backup)
On trying to open it just kicks me out saying its not a valid database
file - so I can't even use the internal compact/repair function
I have tried the usal stuff i.e.
Trying to repair via another access program using dao
DBEngine.RepairDatabase
Opening a new database and importing the old data
microsofts JETCOMP.EXE
plus a few other bits
The only luck I have had is do create a new ODBC connection and use this to
compact the database file. It seems to work and creates a new file
If I try open the new file using Access I get 'Query engine error:
42000:[microsoft][ODBC Microsoft access driver] record(s) cannot be read;no
read permission.'
..
If I then use say crystal to look directly at the ODBC connection I can see
the datatables (so there is still something there), but as soon as I try to
view the data I get the same message.
Is there any way I can get in and some how give read permissions to the
tale, or any other suggestions would be brilliant.
thanks
Andy