Set IDENTITY_INSERT on Append Query (please help fix my sql)

[sisieko]

Does anyone have any idea what i am doing wrong here? I am getting error 3078, Input or query not found. But my table exists in tht location.

SQLstr12 = ("SET IDENTITY_INSERT statusCodes ON " & _
"INSERT INTO statusCodes (statusCode, statusDescription, statusSortOrder, shortStat) " & _
"SELECT [Status Code], [Status Description], [Sort Order], [Short Stat] FROM [Status Codes] IN '" & strOldDBpath & "';")
db.Execute SQLstr12, dbFailOnError

 

[Zion7]

I'm not sure if I'm just not familiar with the SET statement, or you're just way off?

SQLstr12 = "INSERT INTO statusCodes (statusCode, statusDescription, statusSortOrder, shortStat) " & _
"SELECT [Status Code], [Status Description], [Sort Order], [Short Stat] FROM [Status Codes] WHERE txtSomething IN (" & strOldDBpath & ")"

Are you trying to duplicate a record?
Is it possible this way? (locking Issue?)

 

[Craig0201]

Missing WHERE clause.

The SET is fine (assuming you're connecting to a SQL Server).