[AccessD] Dropbox for Access distribution

On Wed, Sep 12, 2012 at 12:06 PM, Brad Marks <BradM at blackforestltd.com> wrote:
> Doug,
>
> In your note about Client 2, you mentioned "This works very well except
> for the odd time when Access goes corrupt"
I would like to learn more about this issue of "going corrupt".

1. What causes it?
   Random fluctuations in the magnetic field of Venus.
2. How to fix it?
  If a decompile/recompile doesn't work, pray that you have a backup
and can re-create your latest changes.
3. What can be done to prevent it?
  Swing a lizard around your head three times during a full moon.
Unfortunately, this only protects you for 2 minutes.

Sorry, couldn't resist.  If you could answer questions 1 and 3 you
would get rich very quickly.

Doug



> I would like to learn more about this issue of "going corrupt".
>
> What causes it?
>
> How to fix it?
>
> What can be done to prevent it?
>
> Etc.
>
> Thanks,
> Brad
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Wednesday, September 12, 2012 1:25 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Dropbox for Access distribution
>
> I have three clients using Dropbox.  For various reasons they are all
> different.  They all set up a shared Dropbox folder on one of their
> computers, which I can access from my computer.
>
> Client 1. Their folder is just used as a convenient drop.  I copy a
> new version of the FE to the shared folder, notify them,  and they
> install it manually on their network.
> Client 2.  Windows Server.  I copy the new version of the FE to my
> shared folder and when a client machine opens the FE it checks for a
> new version and installs it automatically.  This works very well
> except for the odd time when Access goes corrupt and everyone gets a
> bad version (happened this morning)!
> Client 3.  Linux based file server.  I tried to automate installation
> similar to Client 2, but had permissions problems with the file server
> (their network guy was no help) and it won't let me auto-copy files
> from the shared folder on the client computer.  So installs are done
> manually.
>
> Doug
>
>
> On Wed, Sep 12, 2012 at 10:55 AM, Jim Lawrence <accessd at shaw.ca> wrote:
>> Interesting. Keep me posted.
>>
>> Jim
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Wednesday, September 12, 2012 10:19 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Dropbox for Access distribution
>>
>> Has anyone tried using Dropbox to distribute Access FEs or libraries
> to
>> remote clients?
>>
>> It seems like one could set up a dropbox directory on the remote
> machine and
>> a batch file or other
>> system which copies the files to the run location and then opens the
>> database.  Similar to what I do
>> on a network where the batch file copies from the server to the run
>> location.
>>
>> --
>> John W. Colby
>> Colby Consulting
>>
>> Reality is what refuses to go away
>> when you do not believe in it
>>
>> --
>> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com