Multi-Users - Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a reporting database that resides on a server. Multi-users can
access the database at any one time and edit the information stored in the
main table (T1)using a form (F1). They enter the required record number on
one form (F2) which edits a number stored in another table (T2) and opens
form F! for editing.
My problem - User1 requests a particular record, changes the number in T2
and up pops F1 with his record to edit. User2 does exactly the same but wants
a different record. As F1 opens for this second user the form showing on
User1's pc changes to show the same record User2 wanted.
I've set no security on this database except a StartUp form
Please help - the database works fine except for this problem. I belive it
has something to do with locking the record by am unsure how to do it. Would
requesting each user to log-onto the database help ? Even then i'm unsure how
i would lock the records they request.
Thanks to anyone how reads and responds
Andy
 
Andy Bleese said:
I've created a reporting database that resides on a server. Multi-users
can
access the database at any one time and edit the information stored in the
main table (T1)using a form (F1). They enter the required record number on
one form (F2) which edits a number stored in another table (T2) and opens
form F! for editing.
Click to expand...

More info required - what is the purpose of T2? What is the purpose of
entering a record number on F2 to edit a number stored in T2 only to open
F1/T1 for editing? Why not just search F1 for your record?

Regards,
Keith.
www.keithwilby.com
 
I only want the individual record to be available, not all records. How would
I search on F1 for editing, lock said recoed yet have multi-users opening the
same form to edit different records ? Is it possible ?
 
Back
Top