[AccessD] Multiple Frontend Users

Dan Waters dwaters at usinternet.com
Mon May 19 09:42:02 CDT 2008


Ed,

Even with 3 users, splitting is a good preventive measure to avoid data
corruption.  You can put the Access Back End .mdb file on the server, and
put the Front end .mdb files on each user's PC.  Managing 3 users shouldn't
be difficult.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tesiny, Ed
Sent: Monday, May 19, 2008 9:28 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Multiple Frontend Users

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.

 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list