#Deleted record wierd problems

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

Re: #Deleted record wierd problems

On Apr 16, 5:18 am, jim wrote:
> 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

Re: #Deleted record wierd problems

Bruce wrote:
> On Apr 16, 5:18 am, jim wrote:
>> 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...