Daniel Kasak wrote:
Patrick Kirk wrote:
[...]
CREATE TABLE `tblContacts` (
`p_ID` bigint(11) NOT NULL auto_increment,
That's your problem there. You can't have a bigint() column as a primary
key when Access is being used. In fact you probably shouldn't have any
bigints at all if you're usi
Patrick Kirk wrote:
Hi all,
I've installed the latest MDAC and Jet service packs on Windows 2000.
On Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to
check "Don't Optimize columns width", "Return Matching Rows", "Allow
BIG Resu
Hi all,
I've installed the latest MDAC and Jet service packs on Windows 2000. On
Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to
check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG
Results", "Use Compressed
.
-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
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 permiss
