Data not downloading to .xls file but it is in the database

[Ashland78]

OK, I am relatively familiar with Access 2003, but I have been asked to
figure out why the data in that is entered into the database shows it when
looking on the database but it is not generating it to the list of updated
documents. Here is a bit of the background...I just started working at this
company 2 days ago, well the file is an excel file but the path for the file
is generated to a person's C: drive who no longer is employed here. I am
trying to change that path...and am having no luck. Any help would be so
appreciated. Thanks!

 

[Arvin Meyer [MVP]]

Is the file even on their machine? You cannot link to files on machines that
either aren't open, or files that have been deleted.

 

[Alan]

i had this problem before,

if you look at your code you may have something like a "CoPath"
which gives you the directory to where the file is being saved, i'm not sure
how to change that, but what i did was create a new sheet in excel and
create a link to the new work book and update the values from there.