Darryl Collins
Darryl.Collins at coles.com.au
Mon May 19 20:12:48 CDT 2008
As a voice of painful experience - SPLIT IT, and give all the users their own front end. regards Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tesiny, Ed Sent: Tuesday, 20 May 2008 12: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 This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.