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 programmaticall y: 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.
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 programmaticall y: 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.
Comment