[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