Re: What's Up with this #Deleted Thing

[Aaron Edwards]

Well I followed all the advice I got from this community and it worked. Thank you all for the help. Specifically, what did the trick for me was:

1. adding timestamp fields to every table.
2. Making sure every table's primary key was an auto-increment Int ID, not text or any other type of field
3. Using myODBC 3.51.12
4. configuring the ODBC connection with the following options checked: Don't Optimize Column Width, Return Matching Rows, Change BIGINT columns to Int.

Also, it looks like either myODBC or mySQL doesn't support the ADO Recordset.AddNew method, so you'll have to use a Command object to issue an INSERT command instead.

Like Jake said (and I'm sure everyone agrees) it will be nice when we get some good ODBC drivers for mySQL. Thanks everyone.

Aaron