By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,663 Members | 1,638 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,663 IT Pros & Developers. It's quick & easy.

#Deleted record wierd problems

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Apr 16, 5:18 am, jim <j...@nospam.comwrote:
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
Jun 27 '08 #2

P: n/a
jim
Bruce wrote:
On Apr 16, 5:18 am, jim <j...@nospam.comwrote:
>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...
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.