Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record and table name problem!!!

Status
Not open for further replies.

mofp666

Technical User
Feb 21, 2003
1
IT
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top