Link correction for report printing

D

David

I reinstalled MS XP pro after formatting hard drive and erroneously changed
the computer name during installation. This created a different path
hierarchy for my documents including Access 2003 files and has affected the
links between reports and the word document and Microsoft office document
imaging files that I use to print common (paper) application forms.

The error message is as follows:

ISES Database can’t open the file “\\Pc1\My Documents\I S E S\DATA BASE\Copy
of new database\PA Asbestos Application back.tif

The original path for this file was:
(Same as above alert message)

\\Pc1\My Documents\I S E S\DATA BASE\Copy of new database\PA Asbestos
Application back.tif

The new path is:

\\Heydi Corporan\My Documents\I S E S\DATA BASE\Copy of new database\PA
Asbestos Application back.tif


Thus in changing “\\Heydi Corporan\My documents...†for prior start of path:
“\\Pc1\My documents...†makes Access loose the connection or link to this and
other files since Access is looking for the former path hirerchy.

I know I can reinstall operating system and change name again to Pc1 but
that will take several hours considering that I took the time to install SP2,
antivirus program, bunch of software and updates left and right, etc. I
know this problem can be solved directly from Access by somehow linking the
report to the image or word file to their corresponding folder.
Can anyone help? PLEASE!

I know the answer is looking at me but…

Please reply to [email protected] or I can also be reached toll free at (877)
325-0128.

David.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-825d-b123a8964cc3&dg=microsoft.public.access
 
V

Van T. Dinh

1. How hard or how easy to fix it depends on how the original developer
stored the path. The path can just be a value stored in a Record so you can
simply change the value of this Record. OTOH, it can be hard-coded(possibly
as a constant) in VBA and in this case, you will need to modify the VBA
code. It may even be store in a separate file or in the registry. Since
you asked the question, you probably don't know which method was used and
where the information is stored. This can be traced by looking at the VBA
code but only if you familiar with VBA.

2. Changing the computer name does NOT need re-installation of the
software. If you are not familiar and since you will probably need the
Domain Admnistrator's permission to change the Computer Name / join the
network, get someone from I.T. (Network) Support to do it for you. This
should only take about 5 mins for someone who knows how ...

HTH
Van T. Dinh
MVP (Access)



David said:
I reinstalled MS XP pro after formatting hard drive and erroneously changed
the computer name during installation. This created a different path
hierarchy for my documents including Access 2003 files and has affected the
links between reports and the word document and Microsoft office document
imaging files that I use to print common (paper) application forms.

The error message is as follows:

ISES Database can't open the file "\\Pc1\My Documents\I S E S\DATA BASE\Copy
of new database\PA Asbestos Application back.tif

The original path for this file was:
(Same as above alert message)

\\Pc1\My Documents\I S E S\DATA BASE\Copy of new database\PA Asbestos
Application back.tif

The new path is:

\\Heydi Corporan\My Documents\I S E S\DATA BASE\Copy of new database\PA
Asbestos Application back.tif


Thus in changing "\\Heydi Corporan\My documents..." for prior start of path:
"\\Pc1\My documents..." makes Access loose the connection or link to this and
other files since Access is looking for the former path hirerchy.

I know I can reinstall operating system and change name again to Pc1 but
that will take several hours considering that I took the time to install SP2,
antivirus program, bunch of software and updates left and right, etc. I
know this problem can be solved directly from Access by somehow linking the
report to the image or word file to their corresponding folder.
Can anyone help? PLEASE!

I know the answer is looking at me but.

Please reply to [email protected] or I can also be reached toll free at (877)
325-0128.

David.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...-825d-b123a8964cc3&dg=microsoft.public.access
 
Top