Reconnecting Front to Back end in Developer

[Lumpierbritches]

Thank you for your assistance in advance. I'm trying to figure out why on my
computer the front and back ends are ok, when I use Access developer and set up
the program with the front and back ends in the same install folder, I get
errors and no way to reconnect the front and back end on the foreign computer.
Is there something in the developer package that allows this to happen, that
I'm not loading with the program and setup files?

Michael

[Bradley]

Re: Reconnecting Front to Back end in Developer

Lumpierbritches wrote:[color=blue]
> Thank you for your assistance in advance. I'm trying to figure out
> why on my computer the front and back ends are ok, when I use Access
> developer and set up the program with the front and back ends in the
> same install folder, I get errors and no way to reconnect the front
> and back end on the foreign computer. Is there something in the
> developer package that allows this to happen, that I'm not loading
> with the program and setup files?
>
> Michael[/color]

You will need to use the Linked Table Manager add-in to relink your
tables or write/get some code that will refresh the links. The link
stores the physcial logation of the file (eg. C:\database\myd ata.mdb).
When moving the data file to the server the link information needs to be
changed to reflect the new location.
--
regards,

Bradley

[Lumpierbritches]

Re: Reconnecting Front to Back end in Developer

Thank you, I'm aware that it's stored, but when you compile and use developer,
the link manager isn't part of the develpment package, that I'm aware of, so
how do you relink on the foreign machine?

Michael

[Lumpierbritches]

Re: Reconnecting Front to Back end in Developer

In the Setup (developer), there is NO linked table manager. That resides within
Access, as far as I can see.

Michael

[Albert D. Kallal]

Re: Reconnecting Front to Back end in Developer

Well, I am sure that you know any good developer will provide some code that
handles this linking problem.?

Surely you can't expect your users to use, and have to learn about the
linked table manager?
(how much pain are you trying to inflict on your users?. Perhaps you don't
like them very much!! ;-) )

And, as you rightly point out that the runtime does NOT include the linked
table manager anyway!

If you have reached the point of wanting to distribute your application,
then I am sure that a long time ago you hid the ms-access interface. And,
thus since you long ago hid the ms-access interface..then how have your
provided your users with a means to re-link in the past?

Most developers have simply lifted the code that re-links table from here:

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

The code to launch up the standard windows file dialog can be found here:

http://www.mvps.org/access/api/index.html

With all of the above hard code written...after an hour or so you can cobble
together a nice routine that allows your users to re-link. In fact, if the
back end table is in the same dir at the front end...then why no attempt a
re-link in your code to the same dir first? This way, if a user moves the
front end, and back end to a different dir..you will not even prompt the
user...and the user will never even know that re-linking had to happen!

Setting up some routines to handling re-linking scenarios is something that
everyone should incorporate into their applications. I even have a re-link
option that I can set before I send the file to a user (when it starts..it
will re-link to the specified dir).

Anyway..the above code is free for the taking..and you can easily use it to
come up with a solution that fits your needs. Doing this will save tons of
support calls. And, any support call that requires your users to re-link
will also be very easy. You can make a re-link button in your custom
menus...(you are using custom menus...right?? ).

By the time you get around to developing a polished application for
distribution with the runtime..you will have likely had your own re-linking
code running for years.


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pleasenonoSpamK allal@msn.com

http://www.attcanada.net/~kallal.msn

[kling0n]

Re: Reconnecting Front to Back end in Developer

Create a button with this code on click behind it and see if it activates
the linked table manager?

Call Application.Run ("acwztool.att_ Entry")

"Lumpierbritche s" <lumpierbritche s@aol.com> wrote in message
news:2004042109 1018.16988.0000 0176@mb-m11.aol.com...[color=blue]
> In the Setup (developer), there is NO linked table manager. That resides[/color]
within[color=blue]
> Access, as far as I can see.
>
> Michael[/color]