Ensure you have a timestamp(14) field. This will provide the required uniqueness for Access (Jet). I hope this helps.
Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 ----- Original Message ----- From: "Adam" <[EMAIL 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 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 executing DDL queries to MySQL. > > Regards, > Adam > > On Apr 1, 2004, at 4:14 AM, Patrick Kirk wrote: > > > 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 readbale. HOWEVER, queries that rely on the data work > > accurately but show the results as "#Deleted". > > > > I've installed myodbc, the latest MDAC and Jet Service packs. > > > > Is there some test or diagnostic procedure to establish what isn't > > working? I think I've followed all the documented steps but the lack > > of diagnostics makes this very difficult. > > > > Thanks in advance, > > > > Patrick > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
