Reconnecting Front and Backends

[Lumpierbritches]

I'm developing a small program that I would like to have a front and backend,
so when I change the forms, all I have to do is upload the file on the frontend
and if I change the tables, I can append the data. The problem I'm having is
when I break the db, the front and backend go flawless. When I package and
place in the P&D Wizard, I place both in with the Runtime and Workgroup along
with relevant icons. When I install it on a foreign machine, I get errors that
the db isn't linked. If the clients computer doesn't have Access installed, I
don't all the tools. Is there something in the developer package I need to
include to relink the tables and forms (front to backend)?

Michael

[Larry Linson]

Re: Reconnecting Front and Backends

"Lumpierbritche s" wrote
[color=blue]
> . . . I get errors that the db isn't linked.
> If the clients computer doesn't have Access
> installed, I don't all the tools. Is there some-
> thing in the developer package I need to
> include to relink the tables and forms
> (front to backend)?[/color]

No, you need to include code in your application to do that... there's not a
separate something in the Developer Tools for the purpose. But, here's the
good news -- look for the topic "Use multiple databases", subtopic "Relink
tables at startup" in the Developer Solutions sample database. The Orders
and Solutions sample databases for Access 2000 and later versions, are
temporarily hosted at:

http://www.mvps.org/access/downloads/bapp2000.exe

Both example databases are on the installation CD for Access 97 and earlier
versions.

Larry Linson
Microsoft Access MVP