Data Import Macro Not Working!!

[Fox123]

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.

 

[SpentGeezer]

ANy chance of posting the entire macro?

 

[Fox123]

Thank you for responding SpenGeezer however I have managed to fix it by suning a delete query instead of an SQL statement in this part of the macro.