MS Access Multiple User access on NT Server

[Heather]

Advice greatly appreciated in in finalising setup for data entry :
After splitting mdb should an MDE be stored on each local workstation
and the data stored on the server?
Should individual user accounts be setup - if so are there any
specific requirements to be aware of.
Does this eliminate user locking?
Are there any other specific requirements necessary before users enter
data?

Many thanks in advance for any advice received.
regards.

[Albert D. Kallal]

"Heather" <pr*************@optusnet.com.au> wrote in message
news:c3**************************@posting.google.c om...

Advice greatly appreciated in in finalising setup for data entry :
After splitting mdb should an MDE be stored on each local workstation
and the data stored on the server?
Yes, the above really does help in the reliability department. Good for you!
Should individual user accounts be setup - if so are there any
specific requirements to be aware of.
No, you don't have to, but is not a bad idea. Don't confuse the idea of
creating users in ms-access with the issue of creating users on the NT
server. (they are two separate issues). You likely do probably have some
users setup for the NT server. Setting up ms-access security does not need
to be done unless you want to restrict certain users from running reports,
or using certain forms.
Does this eliminate user locking?
Not sure exactly what you mean by locking. If you mean workstations locking
up, that must be eliminated for sure!

Are there any other specific requirements necessary before users enter
data?

Hum, often after splitting you can experience some problems. The following
is a good read:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/a...ers/ba15_3.htm

and

http://www.granite.ab.ca/access/autofe.htm

and

http://www.granite.ab.ca/access/performancefaq.htm
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn