H Happy YN Registered User. Local time Today, 09:47 Joined Jan 27, 2002 Messages 425 May 20, 2004 #1 I am running a docmd.runsql CREATE TABLE...... which works fine when I define text, number or date data types but refuses to recognise types like autonumber? Any ideas on why or a workaround Thanks
I am running a docmd.runsql CREATE TABLE...... which works fine when I define text, number or date data types but refuses to recognise types like autonumber? Any ideas on why or a workaround Thanks
H Happy YN Registered User. Local time Today, 09:47 Joined Jan 27, 2002 Messages 425 May 20, 2004 #2 gOT IT! One has to define it as COUNTER not autonumber