#Deleted record wierd problems

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jim
    #1

    #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
    Tags: None
    • Bruce
      #2
      Re: #Deleted record wierd problems

      On Apr 16, 5:18 am, jim <j...@nospam.co mwrote:
      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:

      Corrupt Microsoft Access MDBs FAQ
      http://www.granite.ab.ca/access/corruptmdbs.htm


      There is a wealth of good information there.

      Bruce

        Comment

        • jim
          #3
          Re: #Deleted record wierd problems

          Bruce wrote:
          On Apr 16, 5:18 am, jim <j...@nospam.co mwrote:
          >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:
          >
          Corrupt Microsoft Access MDBs FAQ
          http://www.granite.ab.ca/access/corruptmdbs.htm

          >
          There is a wealth of good information there.
          >
          Bruce

          Thanks, Bruce...

            Comment

            Previous template Next
            Working...