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
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.