SQL 2000 linking to .mdb database via OLE

Last Post 12 Dec 2006 11:48 AM by shamousrex. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
shamousrex
New Member
New Member

--
12 Dec 2006 11:48 AM
I am trying to save data from a SQL table to a Access table (*.mdb). The foreign databases link up and I can see the table names. If I open a new view and drag a link table to the view tool, There are no columns. Why? Plus is I try and insert data using a stored procedure I get

Error 7392:Could not start a transaction for the OLE DB provider 'MSDASQL'
OLE DB error trace[OLE/DB Provider 'MSDASQL' ITransactionlocal::StartTransaction returned 0x8004d008: ISOLEVEL = 1048576].

Any idea.

Thanks

Rusty
You are not authorized to post a reply.

Acceptable Use Policy