I found one vague mention of relinking tables in the Access 'Building
Applications' book, p.635. Take a look in the 'Developer Solutions'
database. This is supplied with Access 97 but I don't think it's
installed by default so you may have to install it. It also used the
northwind.mdb database, which contains the tables it links to.
In 'Developer Solutions', look (at the bottom I think) for 'Link tables at
startup'. There's some VB code for relinking tables. We adapted this
code for relinking to PGSQL via ODBC. This code is meant to relink tables
when the northwind database can't be found. You'll probably just want to
study the code to figure out how it works, then write your own code. In
your case you'll probably just want to relink everything at startup
regardless, or perhaps just have a 'relink' button on your main form.
Hope this helps..
-Cedar
On Fri, 6 Oct 2000, David Huttleston Jr wrote:
> Get used to deleting and recreating those ODBC links. We
> found out that a ODBC link is static once it's created. For
> example if you add a column in PG it will not appear in
> Access. Delete and recreate the link-- then you will see it.
> Have Fun,
> Dave
>
> On Fri, 6 Oct 2000 15:21:38 -0400, you wrote:
> > Oh, wait.. I see... After I took off the check box, I had to relink it... I
> > couldn't just take of the check box and try to open it again.
> >
> > Adam Lang
> > Systems Engineer
> > Rutgers Casualty Insurance Company