View Single Post
  #1 (permalink)  
Old June 15th, 2005, 08:23 AM
p2ptolu p2ptolu is offline
Authorized User
Join Date: Jan 2005
Location: ipaja, lagos, Nigeria.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to p2ptolu Send a message via Yahoo to p2ptolu
Default append to a query - from access to SQL server

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.

Reply With Quote