I need a function in database"A" that opens a database"B" on click

[J.Alladien]

Dear all,

I need a function in database"A" that opens a database"B" (which is in a
differant location ) when runned! The function must be in database"A"!
Is this possible ?

Thanks in advance!

 

[Stockwell43]

Hi,

Could you place a button on your form in database "A" and hyperlink it to
database "B"? Someone else may know some code but for me, this is how I would
have done it.

Hope this helps!!

 

[microb0x]

Here is one method for doing this:

Dim objAccess As Access.Application
Set objAccess = New Access.Application
objAccess.OpenCurrentDatabase [provide path]
objAccess.visible = True

 

[Tom Wickerath]

Check out this sample by Jeff Conrad:

Creating A Customized Login Screen For A Secured Database
http://www.access.qbuilt.com/html/custom_login.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[fredg]

Dear all,

I need a function in database"A" that opens a database"B" (which is in a
differant location ) when runned! The function must be in database"A"!
Is this possible ?

Thanks in advance!

A Function? Functions return values. there is no value being returned
here.
A Procedure? sure.
Code a click event in database A:

Application.FollwHyperlink "PathToOtherDatabase\DatabaseB.mdb"