I'm trying to run a macro on a database that's located on another computer on our network.
Here's the code I'm running:
Dim Adb As New Access.Application
Adb.OpenCurrentDatabase(thePath & theDBName)
I get this error:
"COMException was unhandled"
"You canceled the previous operation."
Pretty sure I didn't cancel anything...