I used this in Access and after i migrated to SQL this would not work as an append query which it was in access before upsizing, please how do i resolve this , it displays the error below the

INSERT INTO AuditUpdate ( TypeId, ElementSectionId, ElementTypeId, ElementId, ElementTitle, UserId, TimeUpdate )
VALUES ([TypeId], [ElementSectionId], [ElementTypeId], [ElementId], [ElementTitle], [UserId], CDate([TimeUpdate]));


[u]Error message</u>
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'TypeId' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

How many times would you post the same? Cross post at... http://p2p.wrox.com/topic.asp?TOPIC_ID=31705


_________________________
- Vijay G
Strive for Perfection

i had to post again because i had a problem, who can solve it for me

It is enough that you post it once on the right forum. So that people would see it and reply. There is no reason to post that again and again in same/different forums and that doesnt mean that, people would give more importance for such multi-posts. That always would frustrate viewers and tend to ignore such post. I would suggest you never do that.

_________________________
- Vijay G
Strive for Perfection

ok, can you help me now, if you need me to send the database(query) and SQL generated script to you i could and the ASP script.