Hello,
when I open mysql table with access 97 using the latet mysql-odbc driver
( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields because this tables are used by a
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields because this tables
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts, add timestamp or other fields
Andreas Moroder wrote:
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts,
Daniel Kasak schrieb:
Andreas Moroder wrote:
Daniel Kasak schrieb:
You won't break anything by adding a timestamp field. Trust us :)
And no, there is no way around this problem other than adding a
timestamp field.
From the 'mysql' command-line client, do:
... where DATABASE_NAME is the
Hello,
CL Okay, the Access 97 vs. Access 2000 might have something to do with my
CL particular problem now. I will check it using Access 97 later today. I
CL know for a fact, however, that when I first found this problem, I was
CL using Access 97 and the only thing that I changed was the
I see. I added the timestamp field (I never knew there was a field type
of timestamp), relinked the table in Access 2000 and the darn thing
actually worked! Did this just become a requirement in MySQL 3.23? As I
mentioned in a previous post, the timestamp field was not required when I
was
Is anybody aware of a problem when connecting Microsoft Access to MySQL
3.23 where records with AutoIncrement fields claim to be deleted after
entry? Here's what I have:
MySQL 3.23.32
MyODBC 2.50.36
Microsoft Access 2000
Some of my tables have an AutoIncrement Integer field as the primary