Links on CD

  • Thread starter Thread starter Maria Joao
  • Start date Start date
M

Maria Joao

I would need the DB to follow some hyperlinks on a CDROM.
How can I do that in a way that works in different
computers?

Thanks

Maria Joao
 
Maria,

Assuming you mean you want the db to follow hyperlinks to files on the cd:

You can enter the paths to the files in a table with the data type
Hyperlink. Then when you click on the field in the table or on a form it
will follow the path and open the file on the cd.

HTH,
Jsoh
 
Joshua,

Thanks, but I've done that already.
The problem is that each machine has a different path to
the CDRom. How can I solve this?

Thank you

Maria Joao
 
Maria,

Is the CD in a server that could be shared on your network or is it in the
cd drive of each individual machine? If each individual, then is the access
db on the cd too?

Josh
 
I'm thinking that perhaps you can use the computer ID on the network and set up the CD drive as SHARING with a SHARING name.

I've not tried this myself, but theoretically, it should work.

\\computerID\CDSharedName\rest\of\path\and\file\nam

Let me know if this works - yes, you'll have to set it up without a DRIVE letter and with the computerID. Unless of course, you have all your users mapping drive letters (the same letter!) to your CDRom

Hope this helps
Dere

----- Maria Joao wrote: ----

Joshua

Thanks, but I've done that already
The problem is that each machine has a different path to
the CDRom. How can I solve this

Thank yo

Maria Joa
 
I would like de db to work on the CD, and in that case I
would solve my problem, but the db doesn't run from the
CD.It occurs an error!
I need to copy the db to the machine and all the files
from the CD.
I need the db to work on each individual machine, that's
why I would prefer to look for the files on the CD,
because they are about 700MB all together and it is a lot
to copy to each machine.
Thanks

Maria Joao
 
Maria,

The error you get when running from the cd is probably because the file is
read only on the cd. It should still work though, as long as you aren't
trying to modify data or design.

If it was running on the disk, you could use the database name to tell you
what drive is the cdrom.

The following code returns the name of the database including the path.
Currentdb.Name (ie: D:\Access.mdb)

Left(currentdb.name, 2) would return the drive letter. (ie: D:)

Instead of saving the drive letter in your hyperlink fields, you can just
save the relative path and use the drive letter from above.
For example: instead of saving D:\Files\Filename.jpg in the table, save
\Files\Filename.jpg
Then you can use

Application.FollowHyperlink Left(Currentdb.Name, 2) & "\Files\FileName.jpg"

Or you could find the drive letter using the FileSearch command, but then
you'd still have to use relative paths in your table.

Last option would be to put the Cd in a drive that is shared and accessible
to all users. Then save the unc path in your table. (ie:
\\Server\Share\Files\FileName.jpg)

HTH,
Josh
 
Back
Top