Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compacting Access 2000/2003 databases

Status
Not open for further replies.
Feb 10, 2009
52
US
28 Dec 09 14:28
I am having a problem with compacting the back end of an Access database. When I tried Compact and Repair, I receive an error that reads, "Could not find field 'Description." When I click on Help, I get "Could not find field <name> Error 3799. A column name that does not exist is being referenced." I tried exporting the tables to a new database located on my desktop. I periodically did compact. It appeared to work fine. However when I copied the file to the network and compacted, I get the same error. In other words, the version on my desktop works but not the network version. I am using Access 2003, but the file was in 2000 format. I tried converting to 2002/2003 format, but I get the same results.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top