Connecting Tech Pros Worldwide Forums | Help | Site Map

Multi User Form issue

Newbie
 
Join Date: Jun 2009
Posts: 1
#1: Jun 18 '09
Hello All:

I'm new to this forum and the creation of ms access as a multi user desktop application.

I have created a tool for the end user to enter data elements for counts of incidences on a certain day. To setup this process I have a form that first prompts the user to load the unique satation in which they work. This opens a second form which allows the user to select the appropriate date and then enter the data in the appropriate fields. The problem I have encountered is when multiple users access the form simultaneously the intial load form causes a reopen of the second form so that the first user loses the data on there form. Does splitting the database resolve this issue?

Approx users 17 all of which will not be entering data at the same time the overall goal is a once per day data entry for each of the ~18 stations total data elements to be entered 4

ms access version 2000/2003

thank you for your help

Reply