Hello,
I'm working in ASP and I need to modify contents on a Paradox table. I'm able to connect to list contents with this string connection:
odbc_paradox="Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended Properties='DSN=Paradox;DBQ=f:\accesoparadox\db;DefaultDir=f:\accesoparadox\db;DriverId=538;FIL=Paradox 7.X;MaxBufferSize=2048;PageTimeout=600;';Initial Catalog=f:\accesoparadox\db;"
As I say, I can read from the tables, but when I try to update some content:
SQL = "UPDATE NAMES SET "
SQL = SQL & "name='name' WHERE id_NAME='00000'"
SET rec = Bb.Execute(SQL)
I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Controlador ODBC Paradox] La operación debe usar una consulta actualizable.
(that translated says that the operatin must use a updatable query)
Can anyone tell me how can I convert my connection string in a updatable way to modify the table?
Thanks a lot and Kind Regards.
Second give the write permission to f:\accesoparadox folder.