Re: Relink tables

From: Larry Daugherty (Larry.NoSpam.Daugherty_at_verizon.net)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 00:42:19 -0700

Hi Ray,

go to www.mvps.org/access and search for "relink tables" or some variant
thereof. You'll find some code contributed by Ken Getz. The solution may
initially seem cumbersome and overkill, but it isn't. You can copy that
code into a module in your project and modify it to suit. It will solve the
relinking problems beautifully, including bringing up a dialog for the user
to navigate to the back end if necessary.

HTH 

-- 
-Larry-
--
"Ray" <Ray282828@Yahoo.com.HK> wrote in message
news:OJ$GTbMdEHA.3380@TK2MSFTNGP12.phx.gbl...
> I have a split database and need to send to other office to use.  In that
> office, they do not install link manager so they are unable to change the
> table path.  The back-end database is located in the folder of "Data"
under
> the front-end database.  Can someone advise how to relink the table
without
> link manager installed.
>
> Thanks,
>
> Ray
>
>

Relevant Pages

  • Re: Splitting database
    ... you can have queries in the BE. ... If fact, when you use the database spiltter, it puts all tables in the BE ... You will have to have a method to relink to the BE ... >> Set dbs = CurrentDb ...
    (microsoft.public.access.externaldata)
  • Re: Splitting database
    ... If there's a way to move the queries from the FE to the BE (which is ... >> so I keep sending them the whole database to test. ... You will have to have a method to relink to the BE ... > Set dbs = CurrentDb ...
    (microsoft.public.access.externaldata)
  • Re: Relink question
    ... when the database opens, it checks that the Connect strings for the linked ... browse for the correct backend to fix the problem. ... relink, or direct them to further documentation on the network. ... Dim strMsg As String, strCall As String ...
    (microsoft.public.access.formscoding)
  • Re: Relink question
    ... This is a bit of a digression, but here it is anyhow: I built a database in which the Before Update event validates that all required fields are filled in. ... Some of these folks are brilliant in their fields, and make sound choices on matters affecting the lives and safety of others, but I would not be confident in their ability to relink a table. ... I suppose you could then give the user the option of doing nothing and asking for support, or attempting to find the correct backend themselves. ... Perhaps an error could cause an otherwise invisible command button to appear, and the mvps refresh links code could be run from the command button as needed. ...
    (microsoft.public.access.formscoding)
  • When upgrade database from 8i to 9i ,hit the ORA-07445 error
    ... When I did the database upgrade from 8i to 9i, ... Then I try to do relink oracle, relink network, relink client, relink ... Completed: ALTER DATABASE CLOSE NORMAL ...
    (comp.databases.oracle.server)