Hey guys,
I'm trying to build a delete query that will remove records in my main table that match any stored in my history table. The problem is that I keep getting the following no matter how I try to build the thing:
My gripe: No one else has this database, it's not open read only, and I have all the permissions I need for this thing since I built it. My delete query joins tblHistoric to tblWorkNow by account number, and should clear out everything from tblWorkNow that matches tblHistoric, but I get the above error.......any thoughts?
I'm trying to build a delete query that will remove records in my main table that match any stored in my history table. The problem is that I keep getting the following no matter how I try to build the thing:
Could not delete from specified tables. (Error 3086)
You tried to delete data from one or more tables, but the deletion could not be completed.
Possible causes:
You do not have permission to modify the table. To change your permissions assignments, see your system administrator or the table's creator.
The database was opened for read-only access. The database is read-only for one of these reasons:
You used the OpenDatabase method and opened the database for read-only access.
The database file is defined as read-only in the database server operating system or by your network.
In a network environment, you do not have write privileges for the database file.
In Microsoft® Visual Basic®, you used the Data control and set the ReadOnly property to True.
To delete the data, close the database, resolve the read-only condition, and then reopen the file for read/write access.
My gripe: No one else has this database, it's not open read only, and I have all the permissions I need for this thing since I built it. My delete query joins tblHistoric to tblWorkNow by account number, and should clear out everything from tblWorkNow that matches tblHistoric, but I get the above error.......any thoughts?