Re: MyODBC and #Delete / almost resolved

CTED]> Sent: Sunday, January 21, 2001 11:54 PM Subject: Re: MyODBC and #Delete / almost resolved > Thanks to Apollo and Lee for fast responses. Both recommended adding > TimeStamp columns to the table. Lee also recommended adding an > auto_increment column. > > What actually wa

Re: MyODBC and #Delete / almost resolved

Thanks to Apollo and Lee for fast responses. Both recommended adding TimeStamp columns to the table. Lee also recommended adding an auto_increment column. What actually was the culprit was that in the suspect tables, I had a Primary Key on a TinyText field. I have not tried (a) converting the

MyODBC and #Delete

OS: NT 4.0, SP6 MDAC: 2.6 MyODBC: 2.50.36 MS-Access: 2000 (9.0.3821 SR-1) MySQL-OS: Linux, RedHat 6.2 MySql: 3.23.27-beta Symptom: Two of seven tables return all columns and rows as "#Deleted" (and wouldn't you know it, the two most important tables in the database). have been throu