Problems with Linkedserver to MS ACCESS Database

• Mirnes Lemes

  Grasshopper

  Points: 15

  More actions

  June 4, 2009 at 9:37 am

  #205831

  Hello everyone, I had to change my server machine and off course, my SQL server. Now everything works just fine except Linkedserver to one MS Access database which also was working fine but now I can only execute select statements against it but not INSERT/UPDATE/DELETE statements.

  If i execute following statement:

  SELECT * FROM Linkedservername...Tablename

  I can see the result but if I execute this statement:

  DELETE FROM Linkedservername...Tablename

  I got this error message:

  OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKEDSERVERNAME" returned message "Could not delete from specified tables.".

  Msg 7320, Level 16, State 2, Line 1

  Cannot execute the query "DELETE FROM `TABLENAME` " against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKEDSERVERNAME".

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  June 5, 2009 at 4:06 am

  #1005109

  Have you tried the OPENQUERY statement?

  delete

  openquery(Linkedservername, 'select ......... from tablename where ....')