|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Multi-Users - SecurityI'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" <AndyBle***@discussions.microsoft.com> wrote in message More info required - what is the purpose of T2? What is the purpose of news:F9551588-2AAD-43CE-BFBA-498B68BDA942@microsoft.com... > 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. 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 Show quote > 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 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 ? Show quote "Keith Wilby" wrote: > "Andy Bleese" <AndyBle***@discussions.microsoft.com> wrote in message > news:F9551588-2AAD-43CE-BFBA-498B68BDA942@microsoft.com... > > 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 > > > 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 > > >  |
|||||||||||||||||||||||
Other interesting topics