Programmatically link to Back end

[J.J.]

I need some help but existing threads I have scoured discussing linking to
backends each have unique issues. I have a couple of users who are not
computer skilled enough to use Link Manager so I would like to
programmatically link to the master backend when hooked to the server and to
the local replica backend when in the field with a laptop. I envision
something like:
if predefined server site located then use server mdb as backend
else set dbs backend to predefined local replica mdb
conflicting info makes me unsure or even if to use something like
Set dbsCurrent = CurrentDb
I am sure there is a much more elegant and simple way to do this. Thank you

 

[hor vannara]

I need some help but existing threads I have scoured discussing linking to
backends each have unique issues. I have a couple of users who are not
computer skilled enough to use Link Manager so I would like to
programmatically link to the master backend when hooked to the server and
to
the local replica backend when in the field with a laptop. I envision
something like:
if predefined server site located then use server mdb as backend
else set dbs backend to predefined local replica mdb
conflicting info makes me unsure or even if to use something like
Set dbsCurrent = CurrentDb
I am sure there is a much more elegant and simple way to do this. Thank
you

 

[M Skabialka]

I have noticed that you have replied to many of my recent posts, and every
single reply has nothing in it. I am not sure what the point of this is.

 

[Gina Whipp]

M Skabialka,

hor vannara must some sort of drone trying to harvast eMails or something
but just ignore... He/Ahe never has anything to say.

As for your question/s...

For linking tables...
http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm

You might consider setting up a frmWhereAreYou with radio buttons. If they
are 'Home' it would link to one set of tables and if they are 'Away' it
would link to another set of set of tables. Set up the form to open the
Main Menu once the selection has been made.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Peter Hibbs]

J.J.

Did you solve your back-end relinking problem. If not, I have written
some code which should do what you want. Post back if you still need
assistance and I can give you more details.

Peter Hibbs.