CREATE TABLE sessions ( SESSION_ID bigint(20) NOT NULL auto_increment, SESSION_DATE datetime, FILE_ARCHIVE varchar (25), constraint pk_session PRIMARY KEY (session_id) ); or to be MS Access Specific CREATE TABLE sessions ( SESSION_ID bigint(20) NOT NULL AutoNumber, SESSION_DATE datetime, FILE_ARCHIVE varchar (25), constraint pk_session PRIMARY KEY (session_id) ); #### Advanced Microsoft Jet SQL for Access 2000.html Fundamental Microsoft Jet SQL for Access 2000.html Intermediate Microsoft Jet SQL for Access 2000.html Tips and Tricks for Access 2000.html Fundamentals of Relational Database Design.html A Simple Guide to Five Normal Forms in Relational Database Theory.html