Access 97 field named group -> cannot query!!

[ribayah]

Hi,

I have a table which contains a field named 'Group'. I do an insert query through ODBC like this :

INSERT INTO Requests (Group, Department) VALUES ('CAG', 'ITS')

MS Jet refuses this query because of the Group field name. It seems that Jet recognize this as the GROUP BY keyword!

How to bypass that!

Thank You!

 

[jrbarnett]

Try putting some quotes around the fieldname, eg

INSERT INTO Requests (""Group"", Department) VALUES ('CAG', 'ITS')

alternatively if it is being run against a client/server DB, turn it into a pass through query, then you end up doing battle with the back end engine and Jet will not attempt to interpret it.

John