MySQL Forums
Forum List  »  Microsoft Access

Re: What's Up with this #Deleted Thing
Posted by: Aaron Edwards
Date: September 15, 2005 08:47AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3081
September 06, 2005 07:32AM
1928
September 07, 2005 09:23AM
1995
September 09, 2005 07:46AM
2186
September 12, 2005 04:22PM
2032
September 13, 2005 01:37PM
Re: What's Up with this #Deleted Thing
2188
September 15, 2005 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.