Access 97, Create Table Runtime 3290 ERror

[christywarner]

Hello,

I have a 2000 db that I converted to 97.
When I run my program, I get a run-time
error 3290 saying "syntax error in
CREATE TABLE" statement. My code is:

dim str as string
str = "CREATE TABLE tbl_seee1;"
docmd.runsql(str)

Does anyone know why I would see this
error in 97, but not 2000?

Thanks!
Christy.

 

[Norris68]

I don't know why it should work in one and not the other. The thing that beats me is how it works at all. I thought you had to specify at least one column.

Syntax from Access 2000 JET SQL help:
CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])

BTW: Try it without the ';' at the end of the statement - I have no idea why Access keeps putting it in there as it is totally unecessary.