RE: re-indexing records

2001-07-18 Thread Warren van der Merwe
HI You may get other replies to the contrary, but in my knowledge, no you cannot do what you asking. However, I can suggest that you create the table in MYSQL with the auto-number column, then in access delete the auto number column so that when you import into MYSQL no value is passed for that f

Re: re-indexing records

2001-07-17 Thread Carsten Gehling
Drop the index and recreate it alter table you-table drop index your-index; alter table you-table create index your-index(fieldlist); - Carsten - Original Message - From: "Rory O'Connor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 7:55 AM Subject: re-inde