Script to populate Account Name?
Is there a way to automatically populate the Account Name when opening a database? Other than setting it up on each client's preferences>user name
I have 2 related databases (main and secondary) and both need to be open for functionality. In the past users logged in to both databases, but now there's no need for one set of users to use the secondary database and therefore no need to login, however it still needs to be opened.
I was thinking to setup a script from the main database, so that when they login it automatically populates the Account Name for the secondary database and it opens it hidden in the background.
Any ideas on how to accomplish this? Any help is greatly appreciated.