Problem with switching between secured mdb databases. 1

[paulgenga]

Hi,

I have created 3 Databases with shared Tables.
This has helped to ensure centralization of controls to the relevant databases.

Can someone tell me of how best to make it possible to switch. between the databases, without repeated passwords
I have tried the following code and there is no response.

Sub TExpt()
' Initialize string to database path.
    Const strConPath = "\\Server\Exports Database\T-ShippersDbFile.mdb"
    strDB = strConPath & "T-ShippersDbFile.mdb"
    
' Create new instance of Microsoft Access.
    Set appAccess = CreateObject("Access.Application")
    
' Open database in Microsoft Access window.
    appAccess.OpenCurrentDatabase strConPath
    
' Open Orders form.
'    appAccess.DoCmd.OpenForm "Orders"
    
End Sub

Please help
Paul

 

[willir]

Just a thought Paul

What is you use a front end and use an ADO connection string to connect to the other databases. I am assuming the password / account would be synchronized for each.

Richard

 

[paulgenga]

Thank Willir;

When I use the front end back end, with the backend hosted on the server shared by other users. The speed speed of the computer is seriously affected. It becomes too slow.

Is there away to maintain the window (max/min) as in the current database during the switch.

Paul