Verify that you have a primary key and a DateTime Stamp field for your
table.
I do this with a Serial field {Serial int(11) not null Primary Key
auto_increment} as the first field and {DateChanged (TimeStamp)} as the
second field for each table that I intend on accessing from MSAccess.
-----Original Message-----
From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 01, 2001 10:45 PM
To: mysql
Cc: rsa
Subject: Mysql and MS Access
Hi,
I am trying to access a Mysql database from MS Access using the Mysql
ODBC driver. I can connect to the database and open the table and
browse the data but I can not modify anything (the file is read only).
The username I am connecting with have Select, Insert, Update and
Delete permissions.
Any idea on how I can open the database in Read/Write mode?
Thanks
Ramzi
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
