I have code like the following in a Word UserForm (Initialize event):
Code:
Dim db As DAO.Database
' Other code that doesn't matter for now
Set db = _
OpenDatabase("\\ServerName\FolderName\DatabaseName.mdb"
After the database is open I build a SQL SELECT statement to get lists from tables. These lists are used to set combo box row sources on the user form.
The problem, though, is with the Set db line. It worked in Office 2016, and Office 2010 before that. However, in Office 365 the Set db line causes Error 429 (ActiveX component can't create object).
I have tried to sort out if it is a references problem, but no luck so far. Any ideas?
I will be away until Tuesday, Oct. 9. If anybody replies before then, thank you. Please do not think me rude if I do not acknowledge your reply until Tuesday.
Sorry, I just realized the message notes the old OS and Office versions. It is now Windows 10, and Office 365 (replacing Office 2016 today). Most of my work is with Access, and I don't get over here very often, so I'm a bit out of step.