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
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 wrote: >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
