By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Help with hyperlink

P: n/a
I have a table with one field that ia a hyperlink to a pdf file that opens
a specific file.
Since these files are very big, I would need to change the hyperlink path,
so that I could send the hyperlink to one CDROM.

I can do this part, but my problem ist that this DataBase is distributed in
several machines in several places (not connected) and in each machine the
CDROM drive have it's own letter (D: or E: ...).

But I still have another problem: I can find the CDROM drive from some code
that I copied somewhere, but what happens if the computer doesn't have a
CDROM drive? It can have only a DVD drive or a CD RW.

I think the best way to solve my problem should be to ask the user in what
drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.

Can anyone help me with code to perform this?
I don“t know enought VB for this.

Thanks in advance

Maria Joao
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Maria Joćo wrote:
I have a table with one field that ia a hyperlink to a pdf file that opens
a specific file.
Since these files are very big, I would need to change the hyperlink path,
so that I could send the hyperlink to one CDROM.

I can do this part, but my problem ist that this DataBase is distributed in
several machines in several places (not connected) and in each machine the
CDROM drive have it's own letter (D: or E: ...).

But I still have another problem: I can find the CDROM drive from some code
that I copied somewhere, but what happens if the computer doesn't have a
CDROM drive? It can have only a DVD drive or a CD RW.

I think the best way to solve my problem should be to ask the user in what
drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.

Can anyone help me with code to perform this?
I don“t know enought VB for this.

Thanks in advance

Maria Joao


Hi Maria,

how about storing only paths relative to the database in the table
(e.g. "\folder1\subfolder1\file1.pdf")
then get the databases directory via Application.CurrentProject.Path
and sticking that in front of the relative path to get the complete path..

Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath it,
you can copy the whole shebang to wherever you wish..

Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..

Joerg

--
Joerg Glissmann
remove pants to reply.. :-)

Nov 12 '05 #2

P: n/a
Hi,

I think your idea should be the perfect solution, but I still have some
problems:

- If the DB is copied to the Hard drive, then the
Application.CurrentProject.Path doesn't go to the CDRom.
- I could work only from the CD drive, but the database closes because of an
error. I f you can help me with this, I could work only from the CD and
everythig would be OK (except from some delay from working in a CDRom
drive).

Please help me whit this

Thanks in advance

Maria Joao

"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:B43kc.2$i6.222@psinet-eu-nl...
Maria Joćo wrote:
I have a table with one field that ia a hyperlink to a pdf file that opens a specific file.
Since these files are very big, I would need to change the hyperlink path, so that I could send the hyperlink to one CDROM.

I can do this part, but my problem ist that this DataBase is distributed in several machines in several places (not connected) and in each machine the CDROM drive have it's own letter (D: or E: ...).

But I still have another problem: I can find the CDROM drive from some code that I copied somewhere, but what happens if the computer doesn't have a
CDROM drive? It can have only a DVD drive or a CD RW.

I think the best way to solve my problem should be to ask the user in what drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.

Can anyone help me with code to perform this?
I don“t know enought VB for this.

Thanks in advance

Maria Joao


Hi Maria,

how about storing only paths relative to the database in the table
(e.g. "\folder1\subfolder1\file1.pdf")
then get the databases directory via Application.CurrentProject.Path
and sticking that in front of the relative path to get the complete path..

Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath it,
you can copy the whole shebang to wherever you wish..

Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..

Joerg

--
Joerg Glissmann
remove pants to reply.. :-)

Nov 12 '05 #3

P: n/a
Hey Maria,

Application.CurrentProject.Path gives you the current path where the Access
application sits, so it's no wonder it doesn't change to the CDROM drive...
(My suggestion was to copy the application including the data files to the
hard disk, but of course that takes a lot of space..)

I feared that the database has a problem when you run it off a write
protected medium (i.e. CDROM).

I found a hint at googling for the problem:
http://support.microsoft.com:80/supp...180766&SD=MSKB

(also referenced at http://www.kbalertz.com/Feedback_180766.aspx )

Which gives you a sample code that returns the first CDROM drive letter.
(Don't worry, you only have to copy & paste the first gray area, the second
one with the rather few lines show how to use it..)

Hope that helps,

Joerg
Maria Joćo wrote:
Hi,

I think your idea should be the perfect solution, but I still have some
problems:

- If the DB is copied to the Hard drive, then the
Application.CurrentProject.Path doesn't go to the CDRom.
- I could work only from the CD drive, but the database closes because of an
error. I f you can help me with this, I could work only from the CD and
everythig would be OK (except from some delay from working in a CDRom
drive).

Please help me whit this

Thanks in advance

Maria Joao

"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:B43kc.2$i6.222@psinet-eu-nl...
Maria Joćo wrote:
I have a table with one field that ia a hyperlink to a pdf file that
opens
a specific file.
Since these files are very big, I would need to change the hyperlink
path,
so that I could send the hyperlink to one CDROM.

I can do this part, but my problem ist that this DataBase is distributed
in
several machines in several places (not connected) and in each machine
the
CDROM drive have it's own letter (D: or E: ...).

But I still have another problem: I can find the CDROM drive from some
code
that I copied somewhere, but what happens if the computer doesn't have a
CDROM drive? It can have only a DVD drive or a CD RW.

I think the best way to solve my problem should be to ask the user in
what
drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.

Can anyone help me with code to perform this?
I don“t know enought VB for this.

Thanks in advance

Maria Joao


Hi Maria,

how about storing only paths relative to the database in the table
(e.g. "\folder1\subfolder1\file1.pdf")
then get the databases directory via Application.CurrentProject.Path
and sticking that in front of the relative path to get the complete path..

Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath it,
you can copy the whole shebang to wherever you wish..

Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..

Joerg

--
Joerg Glissmann
remove pants to reply.. :-)

--
Joerg Glissmann
remove pants to reply.. :-)

Nov 12 '05 #4

P: n/a
Ok

But if the computer doesn't have a CDROM drive? It can have only a DVD drive
or a CD RW. Does this work properly? I don't have a machine to try this.

Thanks

Maria Joao


"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:XK7kc.4$i6.284@psinet-eu-nl...
Hey Maria,

Application.CurrentProject.Path gives you the current path where the Access application sits, so it's no wonder it doesn't change to the CDROM drive... (My suggestion was to copy the application including the data files to the
hard disk, but of course that takes a lot of space..)

I feared that the database has a problem when you run it off a write
protected medium (i.e. CDROM).

I found a hint at googling for the problem:
http://support.microsoft.com:80/supp...180766&SD=MSKB
(also referenced at http://www.kbalertz.com/Feedback_180766.aspx )

Which gives you a sample code that returns the first CDROM drive letter.
(Don't worry, you only have to copy & paste the first gray area, the second one with the rather few lines show how to use it..)

Hope that helps,

Joerg
Maria Joćo wrote:
Hi,

I think your idea should be the perfect solution, but I still have some
problems:

- If the DB is copied to the Hard drive, then the
Application.CurrentProject.Path doesn't go to the CDRom.
- I could work only from the CD drive, but the database closes because of an error. I f you can help me with this, I could work only from the CD and
everythig would be OK (except from some delay from working in a CDRom
drive).

Please help me whit this

Thanks in advance

Maria Joao

"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:B43kc.2$i6.222@psinet-eu-nl...
Maria Joćo wrote:

I have a table with one field that ia a hyperlink to a pdf file that


opens
a specific file.
Since these files are very big, I would need to change the hyperlink


path,
so that I could send the hyperlink to one CDROM.

I can do this part, but my problem ist that this DataBase is distributed

in
several machines in several places (not connected) and in each machine


the
CDROM drive have it's own letter (D: or E: ...).

But I still have another problem: I can find the CDROM drive from some


code
that I copied somewhere, but what happens if the computer doesn't have

aCDROM drive? It can have only a DVD drive or a CD RW.

I think the best way to solve my problem should be to ask the user in


what
drive are the pdf files and then I would like all the hyperlinks
re-directionated to the ney path.

Can anyone help me with code to perform this?
I don“t know enought VB for this.

Thanks in advance

Maria Joao
Hi Maria,

how about storing only paths relative to the database in the table
(e.g. "\folder1\subfolder1\file1.pdf")
then get the databases directory via Application.CurrentProject.Path
and sticking that in front of the relative path to get the complete path..
Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath it,you can copy the whole shebang to wherever you wish..

Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..

Joerg

--
Joerg Glissmann
remove pants to reply.. :-)

--
Joerg Glissmann
remove pants to reply.. :-)

Nov 12 '05 #5

P: n/a

Hmm.. I would have to try that as well.. I'll have to leave that up to you.

Joerg
Maria Joćo wrote:
Ok

But if the computer doesn't have a CDROM drive? It can have only a DVD drive
or a CD RW. Does this work properly? I don't have a machine to try this.

Thanks

Maria Joao
"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:XK7kc.4$i6.284@psinet-eu-nl...
Hey Maria,

Application.CurrentProject.Path gives you the current path where the


Access
application sits, so it's no wonder it doesn't change to the CDROM


drive...
(My suggestion was to copy the application including the data files to the
hard disk, but of course that takes a lot of space..)

I feared that the database has a problem when you run it off a write
protected medium (i.e. CDROM).

I found a hint at googling for the problem:


http://support.microsoft.com:80/supp...180766&SD=MSKB
(also referenced at http://www.kbalertz.com/Feedback_180766.aspx )

Which gives you a sample code that returns the first CDROM drive letter.
(Don't worry, you only have to copy & paste the first gray area, the


second
one with the rather few lines show how to use it..)

Hope that helps,

Joerg
Maria Joćo wrote:

Hi,

I think your idea should be the perfect solution, but I still have some
problems:

- If the DB is copied to the Hard drive, then the
Application.CurrentProject.Path doesn't go to the CDRom.
- I could work only from the CD drive, but the database closes because
of an
error. I f you can help me with this, I could work only from the CD and
everythig would be OK (except from some delay from working in a CDRom
drive).

Please help me whit this

Thanks in advance

Maria Joao

"Joerg Glissmann" <sp*******@glissmann.de> wrote in message
news:B43kc.2$i6.222@psinet-eu-nl...
Maria Joćo wrote:
>I have a table with one field that ia a hyperlink to a pdf file that

opens
>a specific file.
>Since these files are very big, I would need to change the hyperlink

path,
>so that I could send the hyperlink to one CDROM.
>
>I can do this part, but my problem ist that this DataBase is
distributed
in
>several machines in several places (not connected) and in each machine

the
>CDROM drive have it's own letter (D: or E: ...).
>
>But I still have another problem: I can find the CDROM drive from some

code
>that I copied somewhere, but what happens if the computer doesn't have
a
CDROM drive? It can have only a DVD drive or a CD RW.
>
>I think the best way to solve my problem should be to ask the user in

what
>drive are the pdf files and then I would like all the hyperlinks
>re-directionated to the ney path.
>
>Can anyone help me with code to perform this?
>I don“t know enought VB for this.
>
>Thanks in advance
>
>Maria Joao
>

Hi Maria,

how about storing only paths relative to the database in the table
(e.g. "\folder1\subfolder1\file1.pdf")
then get the databases directory via Application.CurrentProject.Path
and sticking that in front of the relative path to get the complete
path..
Advantage: as long as the database is in the root folder of your
application and the data files reside in the correct folder underneath
it,
you can copy the whole shebang to wherever you wish..

Disadvantage: If you intend to distribute the whole thing via CD, people
need to copy it to their hard disk first (and maybe remove the write
protection on the file) to alter any table entries.
Just my 2ct..

Joerg

--
Joerg Glissmann
remove pants to reply.. :-)

--
Joerg Glissmann
remove pants to reply.. :-)


--
Joerg Glissmann
remove pants to reply.. :-)

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.