Create Table ... Random Autonumber in SQL???

D

Dial222

Is there any syntax for this, or is it the case that Jet does not support
this data type?
 
J

Jeff Boyce

Table definitions in Access can include an Autonumber data type, and you can
set that to incremental or random.

If you could use an append query to "load" a pre-defined table, you could
use this data type.

Good luck

Jeff Boyce
<Access MVP>
 
D

Dial222

Thanks Jeff

I guess I cannot create the table from scratch with SQL then. Will just run
it in VBA.

Regards

Carl
 
J

Jeff Boyce

Carl

The absence of proof <> the proof of absence...

I'm not saying it isn't do-able. Perhaps one of the other 'group readers
can offer the SQL. I simply offered an approach I've used...

Good luck

Jeff Boyce
<Access MVP>
 
S

smcgart

Use the CREATE TABLE command followed by the name of the table.
for example:

CREATE TABLE Books
(
BookID CHAR (20) Primary Key,
BookName CHAR (50),
BookDescription CHAR (100),
PageNumbers CHAR (04),
Author CHAR (50));
 
Top