List:MySQL ODBC« Previous MessageNext Message »
From:Jay Miller Date:August 9 2000 1:03pm
Subject:RE: Access 2000...
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It is important that a primary key is defined in your MySQL table. 
If you are using a query, the primary key must be included in your
query for it to be updatable.  We have had to trouble with this
setup.  I have read in the documentation that there should also be a
timestamp field in your MySQL table, but we have not found that to be
necessary.

> -----Original Message-----
> From: Rolf Herbert [mailto:R.Herbert@stripped]
> Sent: Wednesday, August 09, 2000 3:25 AM
> To: myodbc@stripped
> Subject: Access 2000...
> 
> 
> I cannot get Access 2000 to write to a remote MySQL db using 
> MyODBC. I have
> heard that there is an acknowledged bug but I cannot find any 
> info regarding
> this or a fix on the microsoft site....anyone have any
> information...?  
> 
> cheers...Rolf
> 
> 
> --------------------------------------------------------------------
> - Please check
> "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail
> myodbc-thread1897@stripped  
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOZFWrzYSMQd7VQrOEQIfJQCbBHBXeoEQasuCmuncwoifHwldk0wAoLj9
twr9DmZ0K3M2mSWz4M3xsh7i
=cnY1
-----END PGP SIGNATURE-----

Thread
Access 2000...Rolf Herbert9 Aug
  • RE: Access 2000...Jay Miller9 Aug
    • RE: Access 2000...Jay Miller9 Aug
Re: Access 2000...John Calder9 Aug
RE: Access 2000...John Calder9 Aug