Could not delete from specified tables
-
Hi. i'm working in an ADO App that uses Access and/or MSSQL Server 2000 and my problem is that when i Execute in the Connection the following: DELETE x.* FROM [ODBC;DRIVER={SQL Server};UID=USER; PWD=PASSWORD;DATABASE=WORKING_DB;APP=Microsoft Data Access Components;SERVER=CONTROL02;Description=SQLServer].test_table01 x WHERE clave like '_017%' i get an error "could not delete from specified tables". notes: needs to be with odbc. I didn't made the database. I tried using different user accounts. Tried trusted connection my permissions all to read write with and without alias to x.*, and removed the * my connection string: Provider=Microsoft.Jet.OLEDB.4.0; Password=PPP;User ID=UUU;Data Source=XXX;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False even in Access it won't work. what i'm doing wrong?