CREATE TABLE with AutoIncrement field on Access97?

[Özden Irmak]

Hello!

While creating tables with Jet Sql (4.0) which has an AutoIncrement field, I
cant' set the increment and seed values at Access 97 database...It works
very well with 2000/XP...

The syntax is like that :

Create Table Tb
(
Field1 Counter (1,1)
)

If I remove increment and seed it works well in Access97 like this :

Create Table Tb
(
Field1 Counter
)

Anybody knows why this happens and know a workaround?

Regards...

Özden

 

[John Viescas]

Nope. An Access 97 (JET 3.5) database does not support a Seed.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)