Actually running a form at the start of a database

[ajsingh4]

Hi, I understand the concept of Splash Forms and AutoExec macro's but I am confused as to how to actually get the form running when a user with limited privileges opens the Access database.
I kept myself with Admin privileges and set up another user with limited privileges. However, when trying to view the database with that user's profile, it didn't enforce the form upon them when opening the database. I will update this post with code and screenshots shortly.

[Petrol]

Before you save the copy for the other user go to File - Options - Current Database and set the name of desired form into the "Display Form" box. That should do it.

[ajsingh4]

Petrol,

When you say save the copy for the other user, you mean a copy of the database with a different extension correct? e.g. laccdb? I haven't done this previously, pardon the beginner questions.

[Petrol]

No, I was assuming the other user had their own copy of the DB on their own computer. If you mean they are using the same computer but logged in with restricted privileges, this may be possible but the only way I know to do this would be by making them another copy with the "Display Form" set as above.

Incidentally I don't think you should touch the .laccdb extension. That's just used for a small system file which shows who has the database open, to prevent conflicting updates. (The "l" stands for Lock).

[Petrol]

In other words, I am suggesting you make them another copy, but still with the extension .accdb (or perhaps a compiled copy, with the extension .accde, which can be done from File - Save As - Make ACCDE - Save As).

[ajsingh4]

Understood, however I was just going to have this database on the shared Microsoft OneDrive. At the moment the form is able to distinguish the user's ID from the OS. I am building off of the structure provided by twinnyfo in this post.

https://bytes.com/topic/access/insig...ss#post3788008

[Petrol]

So can you use ab Autoexec macro to open whichever form is appropriate, based on the userID?
(Sorry, I'll be away for the rest of the day. If this doesn't help maybe somebody else can jump in?)