Tom Keatley
tom.p at piedpiper.com.au
Mon May 15 21:37:14 CDT 2006
Just to have my 2 cents..... I have been running a FE BE relationship with around 10 users for some years now and do not re-link at all. Access is looking for a shared drive at DRIVE X on every machine. Our operating systems are XP and win2000 and occasionally win2000 fails to reconnect the network which of course results in an error when opening Access. It happens so infrequently as to be not worth bothering with. Usually clicking on drive x will refresh the connection and everything is fine. When I used to re-link every table it used to take AGES to open Access. I would suggest not doing it at all....if the network connection is working Access will as well Regards Tom Keatley ----- Original Message ----- From: "Bobby Heid" <bheid at appdevgrp.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, May 16, 2006 3:47 AM Subject: Re: [AccessD] To re-link or not to re-link... > Thanks Marty. I'll check that out. > > Bobby > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly > Sent: Monday, May 15, 2006 1:40 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] To re-link or not to re-link... > > > When re-linking try to keep one table open during relink process to avoid > opening and closing ldb file, remove subdatasheets on backend tables. > Once the first table has been refreshed, open a recordset based on that > table. > Continue refreshing. Once finished refreshing close the recordset after > you've opened a bound form (perhaps hidden) for performance reasons > <../performancefaq.htm>. > Performance FAQ's > See > http://www.granite.ab.ca/access/performanceldblocking.htm > and also > http://www.granite.ab.ca/access/performancefaq.htm > > > Bobby Heid wrote: > >>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 >> >> >> > > -- > Marty Connelly > Victoria, B.C. > Canada > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.5.6/339 - Release Date: 14/05/2006 > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.392 / Virus Database: 268.5.6/339 - Release Date: 14/05/2006 > >