Multiple data entry clerks inputting data

aziz rasul

Active member
Local time
Today, 03:18
Joined
Jun 26, 2000
Messages
1,935
I have a shared db where there is a requirement for more than 1 user to enter data in the same form and hence the same table. Up till now there has only been 1 data entry clerk so there has not been a problem.

Would accessing the same form by different users cause a problem, assumming they are inputting different records?
 
you shouldnt have a shared database

you should split the database so each user has their own copy of the code/forms database, which all point to a shared backend database (operating tables)
 
At the moment I have front and back end databases. Each user has access to the front end via a shortcut in thier user areas.

Do you mean that I should have more than one front end copy?

Would it cause a problem if the different users accessed the SAME form in the FE database?
 
Each user should have their own copy of the frontend. That way they can never access the same form. And don't worry about the underlying table: the Jet Engine knows all about record locking.
 
What if the users do not use a form to enter data? and they enter it straight into a table?
 
your users should never ever ever ever even see a table. let alone directly input data.

imagine if you will, one user deleting everything anyone has entered....
 
how can a user enter things directly in a table without the possibility of errors - what if the values ranges you can enter depend on some other field in the table or even in a different table - you cant manage everything with validation rules and referential integrity
 
yes, i know, if i would've set up this database to begin with i would've used a form, BUT i just created a form for them to use instead. sorry for the stupid question post, that was my stupid moment for the day :p
 
if that was your stupid moment, then you should be in pretty good shape. Mine was leaving my ATM card in the machine...
 

Users who are viewing this thread

Back
Top Bottom