The Access DB definitely does not need to be open. In fact, it should
be possible to run your update query even if Access is not installed
on the target system, as the relevant Jet engine is distributed with
all versions of Office including Standard.
What happens if you try to run the SQL of the q
Hello James,
I think for using any forms/running any quires, the access has to be
opened.
Also I think Connection method only used to share the data from the
table/queries.
Try the following code.
Sub MyOpenDb()
Dim appAccess As Object
Set appAccess = CreateObject("Access.Application")
