J
JackStockton
I can create a table with an autonumber field that increments with this
code.
CREATE TABLE tblTest (TestID Counter CONSTRAINT PrimaryKey PRIMARY KEY,
Test TEXT (32))
What I really want though is a autonumber field that uses a GUID. If I
use the Access Table Designer, I just set the field Data Type to
AutoNumber, then change the Field Size from Long Integer to Replication
ID.
Can this be done either via a SQL statement(s) or a VBA function? Do I
have to do this manually with the Table Designer?
code.
CREATE TABLE tblTest (TestID Counter CONSTRAINT PrimaryKey PRIMARY KEY,
Test TEXT (32))
What I really want though is a autonumber field that uses a GUID. If I
use the Access Table Designer, I just set the field Data Type to
AutoNumber, then change the Field Size from Long Integer to Replication
ID.
Can this be done either via a SQL statement(s) or a VBA function? Do I
have to do this manually with the Table Designer?