Does someone know how to append records ignoring records that do not
meet the database restrictions (UNIQUE index field).
I can do it at the server with the IGNORE clause but that clause
that not exist in access.
TIA,
Dante
-
Hi Everyone,
I have just installed mysql 4 on a Linux server I'm comparing it against
MS-SQL to see
it handles one of our DBs better. The DB has over 8 million records MS-SQL
shokes with it.
I have a field defined to be UNIQUE and I need to append from another table
into it from MS-ACCESS