Linked SQL Server Table Problems

jalton · #1 02-11-2010, 01:31 PM

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 · #2 02-11-2010, 02:42 PM

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

jalton · #3 02-12-2010, 08:07 PM

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

Thanks for the help

pbaldy · #4 02-12-2010, 09:52 PM

No problem, glad you got it sorted out.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening linked paradox tables in win 7 problems with UAC	davedejonge	Import/Export Data	3	01-29-2010 09:36 AM
update Linked Table Definitions after the table has columns added/Altered	sesproul	Access	3	01-21-2010 05:10 PM
Linked Table To SQL Server?	snkscore	Import/Export Data	3	12-09-2009 03:36 AM
How to make query based on external access DB's table and the table in linked table?	aquaraider	Queries	2	10-27-2009 05:09 AM
Linked Table Manager	driccardi	Access	4	02-15-2006 08:47 AM