By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

MS Access Multiple User access on NT Server

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
"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.