Multi-Users - Security

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
 
K

Keith Wilby

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.

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
 
G

Guest

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top