Charlotte Foust
cfoust at infostatsystems.com
Mon May 19 16:48:33 CDT 2008
My point is that with multiple users in the same front end, you can[t possibly know what the application is doing and why. When all you have is a hammer, everything looks like a nail, too. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris Sent: Monday, May 19, 2008 10:48 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Multiple Frontend Users Lucky ? Maybe. However, it seems to pay to know what the application doing and why. Whatever solution that works, is a solution. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Monday, May 19, 2008 8:28 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Multiple Frontend Users Then you have been very, VERY fortunate. That is a recipe for disaster. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris Sent: Monday, May 19, 2008 8:45 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Multiple Frontend Users I have had several users use Access successfully using the DB concurrently on a network. However, you might want to discover what its internal tables do. What is its front-end doing is another thing you should look into. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tesiny, Ed Sent: Monday, May 19, 2008 7: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com