Append Queries

N

Nick1966

Hi

I have created an Append query to update records from a table to another
table in a separate database, however the query only works if I remove the
password from the database that I am appending to, is there a way around
this problem.

Thanks


Nick
 
N

Nick1966

No the tables are not linked currently, the table containing the source data
allows multiple entries for the field that I need to append to the external
table. I thought this may cause problems appending the data, especially as
one field is the Primary Key field in the External database. Also the append
query only needs to be run maybe every 6 weeks or less if not required.

Nick
 
Top