CREATE TABLE query doesn't support some field types

Happy YN

Registered User.
Local time
Today, 09:47
Joined
Jan 27, 2002
Messages
425
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
 
gOT IT!
One has to define it as COUNTER not autonumber
 

Users who are viewing this thread

Back
Top Bottom