Re: MySQL and Ms Access - a better description of the problem

2004-04-02 Thread Patrick Kirk
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

Re: MySQL and Ms Access - a better description of the problem

2004-04-02 Thread Daniel Kasak
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