#Deleted record wierd problems

[jim]

I have an access 2003 database and i was having a few problems with it-
for instance every time i tried a compact and repair, access would crash
out - I tried exporting each table to a new database and on exporting
one of the tables i receive the error message 'Record is deleted.'

On looking through the records of said table i find that there is indeed
a record listed as '#Deleted' and I can't seem to get rid of it... I
have deleted any records in other tables that are related to it and
although i can select it and delete it, it just reappears as #Deleted
when i next view the table.

Any help much appreciated.

jim

[Bruce]

On Apr 16, 5:18 am, jim <[e-mail]:

I have an access 2003 database and i was having a few problems with it-
for instance every time i tried a compact and repair, access would crash
out - I tried exporting each table to a new database and on exporting
one of the tables i receive the error message 'Record is deleted.'

On looking through the records of said table i find that there is indeed
a record listed as '#Deleted' and I can't seem to get rid of it... I
have deleted any records in other tables that are related to it and
although i can select it and delete it, it just reappears as #Deleted
when i next view the table.

Any help much appreciated.

jim

That database is corrupted. Before you do anything else make a copy
of that database and don't touch the original any more. Once you have
done that you can look at Tony Toews' site:

http://www.granite.ab.ca/access/corruptmdbs.htm

There is a wealth of good information there.

Bruce

[jim]

Bruce wrote:

On Apr 16, 5:18 am, jim <[e-mail]:

>I have an access 2003 database and i was having a few problems with it-
for instance every time i tried a compact and repair, access would crash
out - I tried exporting each table to a new database and on exporting
one of the tables i receive the error message 'Record is deleted.'

On looking through the records of said table i find that there is indeed
a record listed as '#Deleted' and I can't seem to get rid of it... I
have deleted any records in other tables that are related to it and
although i can select it and delete it, it just reappears as #Deleted
when i next view the table.

Any help much appreciated.

jim

That database is corrupted. Before you do anything else make a copy
of that database and don't touch the original any more. Once you have
done that you can look at Tony Toews' site:

http://www.granite.ab.ca/access/corruptmdbs.htm

There is a wealth of good information there.

Bruce

Thanks, Bruce...