Hello there
I hope someone can help. I have been administering an inherited database in a new job. There is a macro within the database that pulls in customers from an excel file. The Excel file has all customers on it but the macro filters this and only imports the customers that are not already in the database.
For some reason since our network was changed the import has stopped working. I have changed the file path to the correct one in our new network but now I get an error message that says the following
Could not delete from the specified tables. The help says that this is a read only error.
The code for part of the macro that falls down is as follows
DELETE tblTempDealerListAddedFields.*
FROM tblTempDealerListAddedFields INNER JOIN tblDealers ON tblTempDealerListAddedFields.id = tblDealers.id;
I would appreciate any help anyone can provide.
Thanks in advance.
I hope someone can help. I have been administering an inherited database in a new job. There is a macro within the database that pulls in customers from an excel file. The Excel file has all customers on it but the macro filters this and only imports the customers that are not already in the database.
For some reason since our network was changed the import has stopped working. I have changed the file path to the correct one in our new network but now I get an error message that says the following
Could not delete from the specified tables. The help says that this is a read only error.
The code for part of the macro that falls down is as follows
DELETE tblTempDealerListAddedFields.*
FROM tblTempDealerListAddedFields INNER JOIN tblDealers ON tblTempDealerListAddedFields.id = tblDealers.id;
I would appreciate any help anyone can provide.
Thanks in advance.