Database Launcher

[Jimruns919]

I know it is possible to make a Database Launcher that can have login features and set permissions to a menu to be able to open other Databases.



What I curious about is if it is possible to have a login/Main menu database launcher and have the 2nd database which opens keep track of the username and permissions from the first launcher database?

[June7]

What do you mean by 'permissions from the first' - a table of users/permissions in launcher? Can link to table or open recordset in VBA.
What do you mean by 'keep track of'?

[moke123]

I suppose you could have a local table in the 2nd database and use an "Insert Into" statement to add the name and permissions info.

https://learn.microsoft.com/en-us/of...oft-access-sql

Or you could link the 2nd database back to the first and get your info from there.

https://learn.microsoft.com/en-us/of...ansferdatabase

[Micron]

I can only wonder why? If it's to get data, link tables, do automation or import. If it's to use 2nd db code, include the db in project references.