I'm sorry the title is not more explicit, but I don't know what else to say.
About 2 weeks ago I was receiving the message "Error Loading DLL" when trying to import either Excel or Text files using the "Get External Data" tab from the front window of Access 2070, was unable to find the missing dll's as indicated by the Microsoft tech note.
I reloaded Office Professional from scratch after removing it, problem seemed to be resolved.
Today I tried to run a query using the Query Design option from the front Access window, the query is a very simple update for test purposes as I thought I was doing something really stupid :
The table name and the field name are both valid, the field that should be updated is definitely text.Code:UPDATE [MERG Suppliers] SET [MERG Suppliers].Test = "YY"
When I try to run the query nothing at all appears to happen, no error messages and no update.
Please can somebody give me a clue as to what is not going on.
Terry Lawson
Error Loading DLL in Access 2010Error Loading DLL in Access 2010Error Loading DLL in Access 2010Error Loading DLL in Access 2010