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

Reconnecting Front and Backends

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Lumpierbritches" wrote
. . . 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)?


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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.