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

Locking a form

P: 1
Hi

I'm new to Access and are in need of some assistance.

I've got a database that consists of 4 different tables and 4 Forms.
There are 4 PC's connecting to the same database.

I want to create a menu with the forms as options.
Is it possible that when a user logs in to a form, Access locks that form and the rest of the users can't access it.

Thank you,
Mossie
Oct 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: 8
Hi

I'm new to Access and are in need of some assistance.

I've got a database that consists of 4 different tables and 4 Forms.
There are 4 PC's connecting to the same database.

I want to create a menu with the forms as options.
Is it possible that when a user logs in to a form, Access locks that form and the rest of the users can't access it.

Thank you,
Mossie
You could have a lookup table containing 1) a formId, 2)the form name and 3) a boolean flag for 'locked"

When someone opens a form, the flag is updated to true (locked) and when closed, it is updated to false (available).

So, before opening, your command button would have to check the value of that flag (eg using DLookup)
Oct 19 '06 #2

Post your reply

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