Opening Another Access Database onClick

  • Thread starter Thread starter VWP1
  • Start date Start date
V

VWP1

I would like to open another Access database without closing the current
database. I wish to do this with a button on a form.

Please help.
 
hi,

I would like to open another Access database without closing the current
database. I wish to do this with a button on a form.
Click to expand...

Dim AccessExecutable As String
Dim DatabaseFile As String

AccessExecutable = _
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"

DatabaseFile = """C:\PathTo\Database.mdb"""

Shell AccessExecutable & " " & DatabaseFile

Depending on your installation you don't need the path to the executable,

AccessExecutable = "MSACCESS.EXE"

can be sufficent. The quotation marks around the database filename are
necessary.


mfG
--> stefan <--
 
I would like to open another Access database without closing the current
database. I wish to do this with a button on a form.

Please help.
Click to expand...

Code a command button's Click event:

Application.FollowHyperlink "C:\FolderName\MyDatabaseName.mdb"
 
Is this correct?

Private Sub geo_Click()
On Error GoTo Err_geo_Click

Dim AccessExecutable As String
Dim DatabaseFile As String

AccessExecutable = _
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"

DatabaseFile = """E:\databases\geo.mdb"""

Shell AccessExecutable & " " & DatabaseFile

Exit_geo_Click:
Exit Sub

Err_geo_Click:
MsgBox Err.Description
Resume Exit_geo_Click

End Sub
 
Thank you; it works well. Is there a way I could automatically bypass the
warning of "hyperlinks can be harful to your computer..." prompt? I ask
this, because I know the target mdb is in a trusted location.
 
Well it's working, and I encountered a prompt which warned me that hpyerlinks
can be harmful..., ...but the prompt hasn't come up several times now; I've
opened and closed the target mdb a few times, and I do anticipate the prompt
coming back at some point in time, perhaps, when I reboot my computer, or
reopen the current database (where the hyperlink resides). So my question
regarding the automatic bypass still stands.
 
Well, I got the target (fn.mdb) to open, but it doesn't become the focus, it
sits at the bottom in my taskbar. Not a real problem, but I'll be opening it
up dozens of times per afternoon (and late evening). I'd like it to become
the focus instead of waiting for me to click the taskbar.
 
VWP1 said:
Thank you; it works well. Is there a way I could automatically bypass the
warning of "hyperlinks can be harful to your computer..." prompt? I ask
this, because I know the target mdb is in a trusted location.
Click to expand...

You could use the function posted here:

http://www.mvps.org/access/api/api0018.htm
API: Start an app with ShellExecute

which calls the Windows ShellExecute API.
 
No, there is not a way to get around it, aside from maybe hacking some
security settings to your computer.

Application.Followhyperlink opens a file as if it were something downloaded
from the internet... it will call whatever builtin system security prompts go
with that.

Using the ShellExecute API that Dirk pointed you to is my preffered
method... you can dictate what the focus is, window size, etc etc, and do not
need the path to the executable, as it pulls the information from the
registered application for the file passed.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Back
Top