By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Programmatic Relinking

P: n/a
I just need to know gnerally what commands/api I would need to look up
documentation for, if this can be done at all.

I have some users who take copies of an Access database home with them
to do analysis. I am going to split the database however, and that
means that they will have to copy the backend and then relink to that
local copy in their frontend when they are not on the network.

In other words, manually: Copy backend to local computer, disconnect
form network and go home, open local frontend, open linked table
manager, select all, select prompt for new location, click ok, browse
to backend file, etc.

Instead, implemented programmatically: Copy backend to local computer,
disconnect form network and go home, open local frontend, run a
form/command/query(whichever gets the job done), a select file dialog
comes up, user chooses the local backend, the code updates all links.

That way I can set this up as a button the user clicks.

May 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
sh******@cs.fsu.edu wrote:
I just need to know gnerally what commands/api I would need to look up
documentation for, if this can be done at all.

I have some users who take copies of an Access database home with them
to do analysis. I am going to split the database however, and that
means that they will have to copy the backend and then relink to that
local copy in their frontend when they are not on the network.

In other words, manually: Copy backend to local computer, disconnect
form network and go home, open local frontend, open linked table
manager, select all, select prompt for new location, click ok, browse
to backend file, etc.

Instead, implemented programmatically: Copy backend to local computer,
disconnect form network and go home, open local frontend, run a
form/command/query(whichever gets the job done), a select file dialog
comes up, user chooses the local backend, the code updates all links.

That way I can set this up as a button the user clicks.

You can search this group or the web through Google and find lots of
code samples. Here is one of the more popular sources:

http://www.mvps.org/access/tables/tbl0009.htm

--
'---------------
'John Mishefske
'---------------
May 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.