HELP: Can not append access table with some duplicate records to mysql ver 4.

2001-12-20 Thread Dante Alzamora
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 -

How to ignore duplicate records appending from MS-ACCESS.

2001-12-18 Thread Dante Alzamora
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