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)
it
To: [EMAIL PROTECTED]
Sent: 6/29/04 4:03 PM
Subject: Using Access as client all fields are marked "#Deleted"
Hi all,
My setup is windows 2000, Access 2000 and Mysql built from source on
Debian.
Some tables can be seen but all new entries are marked "#Deleted". If I
close the ta
Hi all,
My setup is windows 2000, Access 2000 and Mysql built from source on Debian.
Some tables can be seen but all new entries are marked "#Deleted". If I
close the table in Access and re-open it, its looks fine.
Others have every field marked "#Deleted" and nothing I do makes those
tables reada
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"
Hi all,
My setup is windoes 2000, Access 2000 and Mysql built from source on Debian.
Some tables can be seen but all new entries are marked "#Deleted". If I
close the table in Access and re-open it, its looks fine.
Others have every field marked "#Deleted" and nothing I do makes those
tables
