[AccessD] Multiple Frontend Users

It is generally accepted Access "best practice" to not have multiple 
users in the same FRONT END on a network share.

I would split it.

John W. Colby
www.ColbyConsulting.com


Tesiny, Ed wrote:
> Hi All,
> This is probably a simple question but we're so busy at work I want to
> make sure I don't screw something up.  Have an Access database linked to
> SQL Server 2000 via ODBC.  Actually, there are some Access table in
> there too.  Can I just put the Access database on a network
> server...there will be 3 users...or should I split the database.  I
> think the latter, in case the users want to take snapshots of the live
> data and create Access tables.
> MTIA,
> Ed
>  
> Edward P. Tesiny
> Assistant Director for Evaluation
> New York State OASAS
> 1450 Western Avenue
> Albany, NY 12203
> Phone:  (518) 485-7189
> Fax:  (518) 485-5769
> EdTesiny at oasas.state.ny.us 
>  
> 
> IMPORTANT:  This E-mail may contain confidential material for the sole
> use of the intended recipient.  The use, distribution, transmittal or
> re-transmittal by an unintended recipient of any communication is
> prohibited without our express approval in writing or by e-mail.  Any
> use, distribution, transmittal or re-transmittal by persons who are not
> intended recipients of this e-mail may be a violation of law and is
> strictly prohibited.   If you are not the intended recipient please
> contact the sender and delete all copies.  E-mail transmission cannot be
> guaranteed to be secure or error-free.   The sender therefore does not
> accept liability for any errors or omissions in the contents of this
> transmission.   All e-mails sent to or from NYS OASAS are to be used for
> our business purposes only.  E-mails sent from or to NYS OASAS are
> subject to review by the Agency.
> 
>