Daniel Kasak wrote:

Patrick Kirk wrote:
[...]

CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment,


<snipped>

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 using Access. Try mediumint unsigned.

Dan
Excellent - many thanks. It works fine now :-)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to