access 2007

[Art Vandaley]

Hi,

Source database is in network and the database with linked tables are in
client PC. If there is no database connection it is not possible to work
with database with linked table. How can I solve this problem?

Thanks.

 

[Guest]

You can't.

 

[Guest]

The wording if your question is a little ambiguous so lets be sure of the set
up:

1. The tables are in a file in shared folder on the network.

2. The 'front end' database on the local machine includes linked tabledef
objects pointing to those in the shared folder.

If that's the situation what do you mean by 'no database connection'? If
the linked tabledef objects have lost track of the tables on the network then
use the built in linked table manager (available from the Tools | Database
Utilities menu on the main menu bar) to refresh the links to the tables on
the server.

If the local machine is not physically or wirelessly connected to the
network then you obviously cannot access the tables. The only option then
would be to use Replication.

Ken Sheridan
Stafford, England

 

[John Vinson]

Hi,

Source database is in network and the database with linked tables are in
client PC. If there is no database connection it is not possible to work
with database with linked table. How can I solve this problem?

Thanks.

That's like asking "how can I edit a Word document on the server if
there is no connection to the server".

If you don't have a link to the data, then you cannot work with the
data.

Consider making a copy of the backend (or a small test subset of it)
to your local computer; you can use Tools... Database Utilities...
Linked Table Manager to switch your frontend back and forth between
the local test data and the production backend. Better may be to write
code to do so, and have the code put up a PROMINENT label indicating
that you're in the test or production instance!


John W. Vinson[MVP]