D
Dustin Ventin
I am currently running a database that my users want to link to another
database. As part of this linkup, they want to be able to open the second
database with a click of a button in thier current Access application.
I thought this would be easy, considering I've already learned alot about
Office API's by doing like things with Project, Word, and Excel, but I can
get this file to open. I use the following code:
Dim AccessApp As Access.Application
Set AccessApp = New Access.Application
AccessApp.Visible = True
AccessApp.OpenAccessProject ("C:\xxxx\xxxx\xxxx.mdb")
The shell opens just fine, but when it comes to opening the file, I receive
an error:
"Run-time error 7866 Microsoft Access cannot open thedatabase because it is
missing, or opened exclusively by another user."
Any ideas why this is occuring? Nobody else has the database open, and my
path is correct.
Thank you!
Dustin
database. As part of this linkup, they want to be able to open the second
database with a click of a button in thier current Access application.
I thought this would be easy, considering I've already learned alot about
Office API's by doing like things with Project, Word, and Excel, but I can
get this file to open. I use the following code:
Dim AccessApp As Access.Application
Set AccessApp = New Access.Application
AccessApp.Visible = True
AccessApp.OpenAccessProject ("C:\xxxx\xxxx\xxxx.mdb")
The shell opens just fine, but when it comes to opening the file, I receive
an error:
"Run-time error 7866 Microsoft Access cannot open thedatabase because it is
missing, or opened exclusively by another user."
Any ideas why this is occuring? Nobody else has the database open, and my
path is correct.
Thank you!
Dustin