Insert Into

Insert into Users ([Name]) values ('navnet')

NOTE: Name may be a reserved word so putting it in [] gets around this.

Users.Name is this because Borland isnt standard SQL! I cant recal seeing an INSERT where it is necessary to give the table name in the fields list!

I don't know whether or not Borland uses standard SQL but the fact is that it uses the table names in the fields list...

The application used to run on a paradox database whitout problems but converting it to Access has been rather problematic...

I have found the workaround to create the SQL myself using Quieries instead of Datasets - but it is rather boring to rewrite the program everytime an Insert is needed.

I thought that maybe a newer Access driver for ODBC could solve the problem but so far no luck...

Thomas>I'm using Access XP (the newest version) and I cant use the table in the fields list, so I very mucg dount its going to help :o(

I dont know anything about Borland but even in Access VBA (code) I build my SQL statements dynamically. It does take longer to make but once made its muh more flexibly.

Thomas>Hows it going here?

My conclusion is that Access dosn't understand SQL strings with the table name in the fields list when making an INSERT.

So I have rewritten the program code so I make the SQL myself...

rather annoying :(

you get 10p for the effort....

closing

Thanks Thomas.
"My conclusion is that Access dosn't understand SQL strings with the table name in the fields list when making an INSERT."

Thats what I have been saying all along :o) Nothing wrong with Access here, I just think it VERY unnormal that it is necessary in any SQL