Unable To Update Linked SQL Table

[OrWolf]

I created a front-end application in Access that has linked tables in a converted SQL database. I can update records in all tables, except for two tables of roughly the same type. I get an error message that states:
'ODBC - Update on a linked table 'OrgResolutionLog' failed.

Then a second error message that reads:
'[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates. (#306)

Does anyone have any ideas about where I should look for the problem?

 

[tlbroadbent]

Are you updating the tables directly, from a form or from VBA code? If you use forms, is the form record source a table or a query? Could you post the table structure and any queries used, please?

Thanks, Terry

;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[an0nyM0use]

It is always disheartening when you search the forums and find the exact problem you are having, but then the original individual submitting the problem drops the thread. Anyway, this is exactly the same issue that I am having. Mine is being caused by a Query.

SELECT [Master Table - Key Controls].[Process Team] AS [Process Team], [Master Table - Key Controls].[Key Control Type] AS [Key Control Type], [Master Table - Key Controls].[Key Control Number] AS [Key Control Number], [Master Table - Key Controls].[Key Control Description] AS [Key Control Description]
FROM [Master Table - Key Controls] INNER JOIN [Link Table - Cntrl Obj to Control] ON ([Master Table - Key Controls].[Key Control Number] = [Link Table - Cntrl Obj to Control].[Key Control Number]) AND ([Master Table - Key Controls].[Process Team] = [Link Table - Cntrl Obj to Control].[Process Team])
GROUP BY [Master Table - Key Controls].[Process Team], [Master Table - Key Controls].[Key Control Type], [Master Table - Key Controls].[Key Control Number], [Master Table - Key Controls].[Key Control Description]
HAVING ((([Master Table - Key Controls].[Key Control Type]) Not Like "inherent*"))
ORDER BY [Master Table - Key Controls].[Process Team], [Master Table - Key Controls].[Key Control Type], [Master Table - Key Controls].[Key Control Number];

If there is anyone out there who has any solution for this I would love to hear it.

Thanks,
Kevin

 

[dhookom]

Kevin,
There is absolutely no way that you can update a query that contains a group by.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]