Login Dialog Box

[ugenya]

I don't know if this has ever been done before but I about have 5 different access databases that are used for data entry/reports. Each of these databases have a shortcut to user's desktop. All the databases are located in one dir. Now, what I would like to do is to create a single login dialog box with a combo box where the user can select a database when they need to to login to that database. But I don't know if this is possible. My searches have not yielded anything concrete.
Does anyone have an idea whether this is doable? Please help

Thank you so much!

Bibi

 

[randy700]

Haven't actually tried this, but...

1. Create an additional database that has 2 tables -- login data and database names.
2. Create a form with the combo box and login criteria.
3. If the user logs in properly, use the FollowHyperlink method to open the selected database.


Randy

 

[Pampers]

See Randy for point 1 and 2, for point 3
maybe this is something usefull:

Private Sub Command0_Click()
Dim strAccessPath As String
Dim strDatabasePath As String


'Set Paths
strDatabasePath = "C:\TestDb.mdb"
strAccessPath = "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"

'Start Application and Load Database
Shell (strAccessPath & " " & strDatabasePath)

End Sub

Pampers
Keeping it simple can be complicated