By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Actually running a form at the start of a database

P: 3
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.
Jul 13 '17 #1
Share this Question
Share on Google+
6 Replies


P: 91
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.
Jul 13 '17 #2

P: 3
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.
Jul 13 '17 #3

P: 91
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).
Jul 13 '17 #4

P: 91
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).
Jul 13 '17 #5

P: 3
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
Jul 13 '17 #6

P: 91
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?)
Jul 13 '17 #7

Post your reply

Sign in to post your reply or Sign up for a free account.