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