database path

  • Thread starter Thread starter ocm
  • Start date Start date
O

ocm

Greetings,

I’ve a DB which is split to BE/FE (be in the server and fe in users Pc
since I want to work on it at home, I first deleted the link an
imported the BE to the FE and saved it to my desktop and burn it to
CD. However, when I tried to open it at home from the CD I get th
following error message:

Microsoft Access
‘\\Bcah_fs\col1\app\Etracker\etd.mdb’is not a valid path. Make sure
that the path name is spelled correctly and that you are connected t
the server on which the file resides.

Thanks,
OC
 
Are you saying you deleted all the links for the tables from the Fron
end to the back end and then imported all the tables to the Front end
 
Yes,
I opened the Fe, deleted the link to the Be (to the table) and importe
the table, so I have both Be and Fe in the same location (desktop).

Thanks,
OC
 
Greetings,

I’ve a DB which is split to BE/FE (be in the server and fe in users Pc)
since I want to work on it at home, I first deleted the link and
imported the BE to the FE and saved it to my desktop and burn it to a
CD. However, when I tried to open it at home from the CD I get the
following error message:

Microsoft Access
‘\\Bcah_fs\col1\app\Etracker\etd.mdb’is not a valid path. Make sure
that the path name is spelled correctly and that you are connected to
the server on which the file resides.
Click to expand...

Use Tools... Database Utilities... Linked Table Manager to relink to
the location on your own computer.

Note that changes you make to the data may conflict with changes being
made concurrantly baack at the office.
 
Is it possible that you hard-coded the path in the VBA code?

OTOH, I wouldn't even try to combine them into 1 file. Simply copy both FE
and BE and after you copy these files onto hard-disk at home, open the FE
and use Tools / Database Utilities / Link Table Manager ... to re-link the
Tables from the BE at the new location to the FE.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top