ProgEvalJAA
MIS
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.
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.