Linked Tables 2

[RemyS]

This is really just a question of principle;

Is it really necessary to locate a backend and refresh the links each time a front end is opened?


I've seen code to do this in a few places now, and wonder how essential it is.

By my un-educated understanding, Access (97) uses Linked tables in order to avoid the necessity of re-creating ODBC connections each time they are needed. These links are refreshed each time the backend tables are opened.

The only errors I can think of are the backend missing or being corrupted, in which case a DBA is best placed, and may be the only person authorised, to resolve this.

So all that's needed in these cases is some basic error trapping, to alert the user to notify a DBA.

The only reason I can think for using code to refresh the links may be performance based. ??


Could anyone point out if my logic is flawed somewhere.
I'm not trying to be complacent, just efficient.

Remy Still new to DB's and enjoying learning day by day

 

[tlbroadbent]

I, too, believe it unnecessary to relink each time the front-end database is opened. I've seen programs that relink each time and frankly grow weary of the wait.

However, it doesn't hurt to include relink logic in the program in case an error is encountred. A technique that I have used is to check the connection of a key table at startup. If that link is broken, the code to relink executes. Otherwise the database opens without processing the relinking code. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[HIM]

Would you happen to know of anywhere to find these pieces of code?
I am in desperate need of this for a small project I am building.

Thanks

 

[tlbroadbent]

Check for code on the Microsoft website. Here is a useful link to the "Microsoft Office 2000/Visual Basic Programmer's Guide" topic of "Creating a Linked Table." The article includes a sub-topic "Refreshing Links for Linked Tables" with sample code.

http://msdn.microsoft.com/library/en-us/odeopg/html/deovrcreatinglinkedtable.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Oppenhiemer]

I have posted on this topic in another area - here is the link, you may find it of some help :
thread705-304963