[AccessD] To re-link or not to re-link...

I sometimes put a relink command button on a client app if they have the 
occasional need to relink or refresh the links.

Rocky


Charlotte Foust wrote:
> It seems to me there were some issues in the early versions if the
> linked database were not available (moved, renamed, network down)
> because the condition seemed to persist even when the linked file became
> available again, but I may be misremembering.  In any case, that was
> overcome long ago and may have had more to do with the OS than with
> Access itself. 
>
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Monday, May 15, 2006 9:09 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] To re-link or not to re-link...
>
> Hi Bobby
>
> We've never (since and including Access 2.0) seen any issues by _not_
> relinking at every launch of the app.
> That's for JET tables. Neither have I seen such a need for SQL Server.
> It may be different for other (ODBC connected) engines though.
>
> Why not just disable the relinking and watch what happens?
>
> /gustav
>
>   
>>>> bheid at appdevgrp.com 15-05-2006 17:33 >>>
>>>>         
> Hey,
>
> We have a system that was originally developed in Access 97.  There were
> a number of tables that were linked to the FE.  There were issues (not
> sure what they were as no one remembers and I did not write the
> original) with the system if the tables were not re-linked each time the
> system is loaded.
>
> Well, here we are today and the app has grown into Access XP.  The
> system has grown and now has over 100 tables.  As such, it takes about
> .6 seconds per table to re-link them all.  
>
> Does anyone know what the issues may have been before and if they still
> exist in Access XP?  Anyone have any pointers to further information?
>
> Thanks,
> Bobby
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com