Maintain Split Access Database Links Example

A nice post in USENET on how to maintain links to back end data tables in a split Access database.

From: Albert D. Kallal (...)
Subject: Re: [ACCESS 97] maintaining split database

View this article only
Date: 2001-11-05 11:42:04 PST

Yes, you have to maintain the location with the linked table manager, or you
can roll your own code. I actually have a one record table in the front end
that has 4 fields

ProductionDir (string field - full path to back end - clients pc)
ProductionReLink (true/false field)

DevelopmentDir (string field - full path to back end - my pc)
DevelopmentReLink (true/false field) ...

Some other solutions:

This one is from MS themselves:;en-us;208295

Related Scribbles:
  • Microsoft Access Links
  • MS Access Notes

  • ID: 532
    Date Updated:
    2004-09-13 11:31:54
    Date Created:
    2004-08-18 11:05:07


     >> Leonard Chan's Homepage  >> Scribble Web  >> Maintain Split Access Database Links Example is hosted by Perceptus Solutions Inc.