Insert into Syntax error?
-
I have an application the adds records to an MS Access database. When the DataAdaptor.update command is issued I get a Syntax error in insert into statement. I am using command builder and only get the error on one table. That table has two fields which are the problem. They are called "Password" and "Usergroup." If I rename the fields it works without any problem. So why not just rename them? Simple right. No, the database is used by another application and chances of getting it changed is slim at best. Any ideas as to how to work around this? Any help would be greatly appreciated. Mike :((
-
I have an application the adds records to an MS Access database. When the DataAdaptor.update command is issued I get a Syntax error in insert into statement. I am using command builder and only get the error on one table. That table has two fields which are the problem. They are called "Password" and "Usergroup." If I rename the fields it works without any problem. So why not just rename them? Simple right. No, the database is used by another application and chances of getting it changed is slim at best. Any ideas as to how to work around this? Any help would be greatly appreciated. Mike :((
mikhaelb wrote: I am using command builder :eek: X| See MSDN: Weaning Developers from the CommandBuilder[^]
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
-
mikhaelb wrote: I am using command builder :eek: X| See MSDN: Weaning Developers from the CommandBuilder[^]
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
-
Then how is it used by the other application? I don't use Access but, maybe it permits escaping of column names with square brackets. e.g.
[Password]
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.