Changing a path on a split data base

[Guest]

I have developed forms, query's, macro's one computer and then want to copy
and run them on a another. The problem is that the path to the data is
different on each computer. The data bases are split on both machines,
giving me a error when I copy down and run. How can I change the path?

 

[SusanV]

You can change the mapping via the Tools Menu>>Database Utilities>>Linked
Table Manager.

Assuming your backend db (the one with the actual tables) is in a shared
directory which both client computers connect to, use the UNC path (i.e.,
\\server\sharename\backend.mdb ) rather than a mapped drive (i.e.
(X:\backend.mdb)

If, on the other hand, each computer has both front-end and backend on it,
but the backend is in a different folder (such as for development purposes)
either make the backend directory a standard location or change it on each
PC.

 

[Guest]

Linked Table manager does change all tables linked to the be data base but
when I access the be table thru the a form it reference the be table on the
other machine . That version of the table is not even on the 2nd PC. The
bottom line is that I can't devolped on one machine and copy the front end to
the 2nd machine.

 

[SusanV]

Hi Bob,

I'm not sure what you're saying here - the form has to reference a table IN
the database it resides in whether it's a linked table or is actually *in*
that database.

For instance, I have a front-end I distribute to my users. While I'm develop
it on my PC, the backend is on my PC (a copy.) When I'm ready to deploy it
to my users, I change the table linking to the live backend, which resides
on a server share, then compact and repair, then push it out to my users'
PCs via a script. So long as you use a UNC rather than a mapped drive it
doesn't matter where the db was developed.

Unless you're setting the datasource for this form via VBA, I don't see how
you could be getting an outside source.

 

[Guest]

I don't know what is causing it. Could it be that I developed the forms, etc
before I split the data base. I have copied the split data base from the
clients computer to mind, and when I display the be I get the correct table
but when I display the tabel in the front end I get a old table I original
had on my computer for testing. What do you mean by the comment " I change
the table linking to the live backend" How can I do this. By the way I'm a
OLd volunteer working for a Non Profit with little money to spend on things
like this.

 

[SusanV]

Oh ok, I think I see what's happening here.

First, make sure you copy both the frontend and the backend to the PC. Note
the location where you placed the backend. Then on the front-end database,
where your forms reside, go to the tools menu, database utilities, linked
table manager and change the table linking there - otherwise the front-end
still is going to look for the tables in the old location from the
development PC.

If you have multiple users sharing this database, the backend (containing
the actual tables) should be in a central location (shared folder) and each
user should have their own copy of the frontend (containing the forms,
reports, *linked* tables)

Hope this clears things up, post back if you still have trouble,

SusanV

 

[Guest]

That only works for linked files. The Front End does show up as linked file.
I do have a number of linke files that does work for them with the path of
these pointing to the back end.

 

[SusanV]

What do you mean by "linked files"?

That only works for linked files. The Front End does show up as linked
file.
I do have a number of linke files that does work for them with the path of
these pointing to the back end.

 

[Guest]

Files that are linked to my data base, such as I have a file with codes of
marital status that is linked to the Marital status field in my table.
I have found away around my problem by going back to a previous front end
and recreating some of the forms and query's.
Thanks for your help and sticking with me.
Bob

 

[SusanV]

Oh, ok,. I didn't realize you were doing this.

best of luck!

Susan