I've seen this before and do not exactly remember why, think it had
something to do with relationships and links, try removing all
relationships and see if that helps, if not try deleting tables and
relinking them from scratch (found the link manager doesn't always fix
problems for some reason)
There is a section in the MySQL manual titled `Programs Known to Work with
MyODBC' and section called `Access`.
http://dev.mysql.com/doc/mysql/en/MyODBC_clients.html
Look at this section and let us know if you are still having issues.
-Original Message-
From: Daniel Eliav Sharvit
To: [EMA
Patrick Sherrill wrote:
Ensure you have a timestamp(14) field. This will provide the required
Thanks all but I reposted and the problem was my primary key being a BIGINT
which Access can't display. I should have closed off both threads.
--
MySQL General Mailing List
For list archives: http://list
AIL PROTECTED]>
To: "Patrick Kirk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, April 03, 2004 11:54 AM
Subject: Re: Using Access as client all fields are marked "#Deleted"
> Osvaldo's question is a good one. How are you connecting to the M
Osvaldo's question is a good one. How are you connecting to the MySQL
instance?
I use MySQL and Access as you are, but I use a MySQL instance running
on OS X. However, I don't have that problem. I use linked tables to
bring the MySQL tables into MS Access.
I have had quirky behavior when execu
What type of connection are you using?
Linked table or you connect on demand?
Osvaldo
-Original Message-
From: Patrick Kirk [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 7:32 AM
To: Osvaldo Sommer
Subject: Re: Using Access as client all fields are marked "#Deleted"