Path Error?

[zufie]

Hi,
I''ve got 2 Access databases that are linked.

When I attempt to access the Front-End database (WHLD, D =
Development) I get one of the following errors:

'C:\Documents and Settings\jmarruff.IDPH\Desktop\WHLPData.mdb'

'WHLPData.mdb' is the Back-End database containing only tables and
data/values in these tables.

What is also strange is that 'WHLPData.mdb' is shown in the error as
'WHLPData.mdb',
P = Production!

That is, why is it mentioning the Production Back-End database?

---OR---

I get the error:

Could not find the file 'C:\Documents and Settings\jmarruff.IDPH
\Desktop\WHLPData.mdb'

Why is it still looking for the database in the incorrect place/path?

I have the databases in the place/path on the server where they need
to be!?

How do I fix this?

Thanks,

John

 

[ErezM via AccessMonster.com]

hi
go to tools->databse utilities->linked table manager, and check all tables,
then "show" access where are the tables (the location of the mdb back-end)

if this proccess stopped in the middle in the past, you'll need to show acces
the back end file for every table seperately, otherwise it will be enough to
show it once, and all linkes will be refreshed

good
luck
Erez