Well that was simple. I changed from FileDSN to UserDSN and i don't get that same error.
I was originally going to use this but once i had copied your maxtest dsn file to the specified directory i saw it show up on the File DSN menu, not User DSN.
Now i am getting this. I am currently trying to diagnose it...
DebugLog:(3) Error executing statement : [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. :
And the line it doesn't like is
DebugLog:CREATE TABLE person (id integer primary key AUTO_INCREMENT, forename varchar(30), surname varchar(30) )
odd that it works for you but not me. again it must be something really simple i am not doing properly...
Oh well, the joy of programming...
Cheers
Glenn
I was originally going to use this but once i had copied your maxtest dsn file to the specified directory i saw it show up on the File DSN menu, not User DSN.
Now i am getting this. I am currently trying to diagnose it...
DebugLog:(3) Error executing statement : [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. :
And the line it doesn't like is
DebugLog:CREATE TABLE person (id integer primary key AUTO_INCREMENT, forename varchar(30), surname varchar(30) )
odd that it works for you but not me. again it must be something really simple i am not doing properly...
Oh well, the joy of programming...
Cheers
Glenn