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
Newsgroups: comp.databases.ms-access
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:
http://www.mvps.org/access/tables/tbl0010.htm

This one is from MS themselves:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208295


Related Scribbles:
  • Microsoft Access Links
    		•
  • MS Access Notes
    		•

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

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Maintain Split Access Database Links Example
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.