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

  • Thread starter Thread starter Guest
  • Start date Start date
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>
 
Thanks Jeff

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

Regards

Carl
 
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>
 
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));
 
Back
Top