Append Query on Linked Tables corrupting database

[TerryL]

I am running Access 2002. Files are in 2002 format. Application is split
into a front and back end databases. The append query is coded in the front
end database. When the query is run all records are appended correctly.
However, if you immediately do a Compact and Repair on the front end
database, or do other functions first, you get the Access Must Shut down....
error. If I go into the back end database and delete the records in the
appended-to table and then re-launch the front end database the problem goes
away.

Does anyone have any idea what is causing this and how to fix it?

 

[[MVP] S.Clark]

Import all objects to a new .mdb file. Recompile. Compact and repair.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[david epsom dot com dot au]

end database. When the query is run all records are appended correctly.


Do you have an autonumber field? There is an autonumber bug when appending.

(david)

 

[TerryL]

No autonumber fields. I re-designed that part of the application to do an
Update query to a different table. No loss of functionality but I had to
sacrifice some backup functionality. I can run the update and do a Compact &
Repair with no problems.

I would still like to know if the append problem is a known bug in Access
and if there is a fix for it.

 

[david epsom dot com dot au]

I have never heard of any other append bug. (I wondered if this
was a new feature of that bug). We don't see this, but we use
A97 format for our data, A2K format FE, using A2K, A2K2, A2K3.

But I haven't seen anybody else with a complaint about this.

I would suggest re-linking, but given that I haven't heard of
the problem, I don't object to Steve Clarks suggestion.

(david)