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

Access: Multi person Entry Form

P: 6
Hello. I am tring to create a form that multi people use perhaps at the same time to enter daily counts for their production output.
Scenario:
There is 10 offices. I created 10 tables named after each office.
Within each table I have Date, Scanning Total and Printing Total

I want each person (office) to be able to log in and enter in their daily total.

Should I create a form that has cmd buttons for each office and they enter their info from there.

Can multiple people access the form at the same time since they are accessing different tables?
Sep 15 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Hello. I am tring to create a form that multi people use perhaps at the same time to enter daily counts for their production output.
Scenario:
There is 10 offices. I created 10 tables named after each office.
Within each table I have Date, Scanning Total and Printing Total

I want each person (office) to be able to log in and enter in their daily total.

Should I create a form that has cmd buttons for each office and they enter their info from there.

Can multiple people access the form at the same time since they are accessing different tables?
The normal way to do this is to use the Database Splitter wizard (Tools>Database Utilities in Access 2003) to split the database into a 'front end' and a 'back end'. The front end holds forms, queries, etc. the back end holds the tables.

Each computer gets a copy of the same front end, which are then linked to one and the same copy of the back end holding the data that resides on a server (or computer acting as a server).

This way each person can use whatever forms reside in their front end without conflict from anyone else. All computers are accessing the most uptodate data as well since all are working on the same back end.

Please see this link as well for additional information:http://allenbrowne.com/ser-01.html

Regards,
Scott
Sep 15 '07 #2

Post your reply

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