having a control center form that opens other databases

[bigdazzer]

hi all, at work we are connected to many servers, on those servers reside databases about 7 in total. my aim is to have a central form that can open automatically from start up that allows the end user to click on a control tab to open the databases that reside on the servers. all databases have been split so the front ends reside on individual work computers and the tables reside on the back end on the server drives. any ideas on how i can achieve this?

 

[Corticus]

Welcome!

Well Microsoft has this code all over the place, I can't seem to get it to work, but I found about fifty references to it, maybe you'll have better luck:

' Include following in Declarations section of module.
Dim appAccess As Access.Application

Sub DisplayForm()
    ' Initialize string to database path.
    Const strConPathToSamples = "C:\Program " _
        & "Files\Microsoft Office\Office\Samples\Northwind.mdb"

    strDB = strConPathToSamples & "Northwind.mdb"
    ' Create new instance of Microsoft Access.
    Set appAccess = _
        CreateObject("Access.Application")
    ' Open database in Microsoft Access window.
    appAccess.OpenCurrentDatabase strConPathToSamples
End Sub

HTH,

 

[bigdazzer]

Thank you for your assistance i shall give this a try and let you know of the results.