sql server odbc: updating a linked Access table -- sql server odbc

updating a linked Access table

jaylou
10/11/2007 1:00:01 PM

sql server odbc: Dont shoot the messenger....
I inheited a system that uses an Access MDB as the front end with local
tables in it. There is a SQL server 2005 database which pulls data from the
Access tables and inserts into SQL tables to create invoices. Information is
keyed into Access, at the end of the month, they have a Power Build app that
calls a SQL SP to pull the data out of access and inserts into SQL 2005.
then they want to update a control table in the Access MDB, that is what is
failing with the below error:
10/11/2007 12:12:59 : 7390 : SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver][SQL Server]The requested operation could
not be performed because OLE DB provider "Microsoft.Jet.OLEDB.4.0"
for linked server "<linkedName>" does not support the required transaction
interface.

Does anyone know if it is possible to update the Access table from PB going
thru SQL? If so do you have an example?

TIA,
Joe

Re: updating a linked Access table

Mary Chipman [MSFT]
10/11/2007 6:02:59 PM

Can you just do an end run around PB and push it into the SQLS table
directly from Access? That would be my recommendation.

-mary

On Thu, 11 Oct 2007 13:00:01 -0700, jaylou
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.