468,136 Members | 1,484 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,136 developers. It's quick & easy.

MS Access Multiple User access on NT Server

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.
Nov 12 '05 #1
1 3545
"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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by indie | last post: by
8 posts views Thread by Frnak McKenney | last post: by
7 posts views Thread by Robin Tucker | last post: by
6 posts views Thread by Peter Frost | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
92 posts views Thread by Jeffrey P via AccessMonster.com | last post: by
13 posts views Thread by evancater | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.