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].