I have an update query that I want to run on database startup but I don't want the update message to appear. I've tried creating an AutoExec macro with the query in it but can't avoid the message.
I may be better with VBA code running on startup so the setwarnings can be false but I don't know how to write the code.
The update query SQL is:
UPDATE tblCustomers SET tblCustomers.SubscriptionExpired = True, tblCustomers.CustomerStatus = 2