I use jet 4.0 to connect to an access97 database empty( No table). I have tried to create a table like this:
"Create Table User(ID int,DOMAIN text(50))"
It give me a syntax error. but if i write:
"Create Table User(ID int,LanDOMAIN text(50))"
All works perfectly!!!.
Same things for this:
"SELECT LAST(ID) AS LAST FROM USER"
Does'nt work.If i rename in this way:
"SELECT LAST(ID) AS LREC FROM USER"
ALL it',s ok.
I don't have all this problem using a simple OLE connection via Microsoft ACCESs database driver.
Anyone has any idea?
Thanks
Master of puppet,666
"Create Table User(ID int,DOMAIN text(50))"
It give me a syntax error. but if i write:
"Create Table User(ID int,LanDOMAIN text(50))"
All works perfectly!!!.
Same things for this:
"SELECT LAST(ID) AS LAST FROM USER"
Does'nt work.If i rename in this way:
"SELECT LAST(ID) AS LREC FROM USER"
ALL it',s ok.
I don't have all this problem using a simple OLE connection via Microsoft ACCESs database driver.
Anyone has any idea?
Thanks
Master of puppet,666