[Error=-3049] Could not delete from specified tables.
I have an Access database online, which views fine using this idc file...
Datasource: millenium
Template: database.htx
SQLStatement: SELECT * FROM [Table1]
+ORDER BY Table1.cfrom ASC;
But will not delete a record using this IDC file.
Datasource: millenium
Template: ilandelete.htx
SQLStatement: DELETE FROM Table1 WHERE Table1.id = %[delrec]%;
Delrec is the number of whatever field is being viewed, and this used to
work until it was moved to a different server. Everything else works 100%,
all records can be viewed as expected. It's just deletign that causes a
problem. Table1 does exist, and so does the field named ID.
Why could this be?
