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 key
type to a standard key or (b) changing the column type to char() or
varchar(). However, removing the Primary Key made the table readable.
However, I cannot edit the tables. Access claims all are unupdatable. I
suspect this is due to not having a unique key for Access to force control
through, but would like to have that confirmed.
---- orig msg ---
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 through the install process several times without a change in symptoms.
Oh, the correct number of rows are returned - the data is just unusable.
Any help is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
