Multi-Users - Security

23 Oct 2006 9:38 PM

Andy Bleese

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

24 Oct 2006 7:39 AM

Keith Wilby

"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

Show quoteHide 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

24 Oct 2006 12:14 PM

Andy Bleese

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 quoteHide 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
>
>
>