Linked SQL Server Table Problems

[jalton]

I currently have a linked table to MS SQL server 2008 that has an identity field that increments as records are added. Everything was working fine from Access to SQL server until I added a trigger event in the SQL server database for the linked table then I can no longer insert new records.


I get the error
"could not execute query; could not find linked table. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.tblContacts'. (#208)"

Updating records works just fine.
Is there something I'm doing wrong or is it something I will have to work around?

Thanks

[pbaldy]

Can you add a record directly on the server? It sounds like the trigger is failing. What does it look like?

[jalton]

That was the problem.
I tested it in another place.
But didn't realize that I was getting errors

Thanks for the help

[pbaldy]

No problem, glad you got it sorted out.