Hale, Jim
Jim.Hale at FleetPride.com
Mon Jun 19 10:30:25 CDT 2006
Yes, you are basically replacing the copy on the web server so any changes in that database that occur from the time you open the local copy then save it back to the server are lost. This works for me but I don't think is appropriate for a heavy traffic site. Jim Hale -----Original Message----- From: Kath Pelletti [mailto:kp at sdsonline.net] Sent: Monday, June 19, 2006 1:18 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SQL and Access Jim - this sounds interesting. So do you lose details when you replace the mdb? Or is there some replication? Kath ----- Original Message ----- From: Hale, Jim To: 'Access Developers discussion and problem solving' Sent: Saturday, June 17, 2006 3:49 AM Subject: Re: [AccessD] SQL and Access I don't think so. It makes the web folders appear in windows explorer so you can copy files, etc.. I think what it is actually doing is ftping a copy of the file (such as the mdb) to your computer and ftping it back once you close Access. This works fine for me since my site is not high traffic but is NOT the same as a true FE-BE setup.(I actually had my data, queries etc all in the web DB so I wasn't using a FE-BE setup. The problem this creates, of course, is you lose any changes to the web database (such as a new retail order!) when your copy of the mdb is copied back to the web and overwrites the "old" copy. Someone more technical might jump in here and give a clearer explanation of how webdrive works. Jim Hale -----Original Message----- From: Doug Murphy [mailto:dw-murphy at cox.net] Sent: Friday, June 16, 2006 12:28 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL and Access Jim, Saw your response and am interested in Webdrive. Does it allow you to connect a FE to your web database? Doug *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- 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 *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.