Can't delete a record

[Guest]

I have a record in an Access 2000 table that I can't delete. When I try to
delete it,
it states the search key was not found in any record. I have seen a similar
posting here but the suggestion was to open a new table and not copy that
item over - I can't do this as the database is huge.

 

[Guest]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

If all else fails

Creat a new database
Import everything but the table(s) with the bad record
Copy only the table structures of the table(s) with the bad record
Link to the tables with the bad record
Use an append query to append the new table with the information from the
affected table selecting everything but that record

 

[Aaron Kempf]

in other words-- MDB is 'too unreliable for real world usage'

SQL Server has built-in enterprise level backup functionality

Just use Access Data Projects; you'll be much happier
SProcs are 1000 times more powerful than silly little MDB queries