I can't append records into a linked table!?!

[wrek]

We, over here in the stone-age, just switched over from Access 97 to Access 2002...

I used to have a routine that:

Ran a delete query and then an Append query to add updated records to a LINKED table.

Reason I did this (and not a MakeTable) was to preserve indexes, keys etc

A2002 wont let me do this now...(Operation must use an updatable query)


Help, anyone? Suggestions?

Thanks in advance...

 

[AlienRay]

You absolutely can run an Append Query on a linked table. The problem you are experiencing stems from the fact that the RecordSet generated by your query is not updateable. This is usually caused by the way the joins between tables are set up.

Can you change the Query Properties to read "Yes" for "Unique Records"? That might clear up your problem.

 

[wrek]

Hi AR,

I changed the properties to Unique Records = Yes...

...same error message

 

[wrek]

Hi Pat,

The linked table's source is just another Access database...owned by me as well.