Linking graphic files

I have a large database with linked graphics as part of the records. The
database also has a data access page so users without Access can view the
information (reason for linked graphic files, since Data Access pages can
deal with OLE objects). I need to put the database on a CD, along with the
graphic files, for distribution (it will be run from the CD, not from a hard
drive so I can't have them install the files in the same path as I have
them). As individual computers may have different CD Drive letters, is there
a wild card for the linked file path that can be used instead of refering to
a drive letter? Something like %CD%\{directory name}\{filename.jpg}?

Hi,

Application.CurrentProject.Path gives you the path of the current database,
you can start from there...
--
Kind regards
Noëlla


"Obe" wrote:

I have a large database with linked graphics as part of the records. The
database also has a data access page so users without Access can view the
information (reason for linked graphic files, since Data Access pages can
deal with OLE objects). I need to put the database on a CD, along with the
graphic files, for distribution (it will be run from the CD, not from a hard
drive so I can't have them install the files in the same path as I have
them). As individual computers may have different CD Drive letters, is there
a wild card for the linked file path that can be used instead of refering to
a drive letter? Something like %CD%\{directory name}\{filename.jpg}?

I was hoping I could get away without writing code, but the more I research
the more I realize that I'm going to have to enter the world of VB to make
this work unless there are any other ideas out there.

I suppose I could use SET CDROM=%CD:~0,2%, and pull the subdirectory and
filename from the table.

"NG" wrote:

Hi,

Application.CurrentProject.Path gives you the path of the current database,
you can start from there...
--
Kind regards
Noëlla


"Obe" wrote:

I have a large database with linked graphics as part of the records. The
database also has a data access page so users without Access can view the
information (reason for linked graphic files, since Data Access pages can
deal with OLE objects). I need to put the database on a CD, along with the
graphic files, for distribution (it will be run from the CD, not from a hard
drive so I can't have them install the files in the same path as I have
them). As individual computers may have different CD Drive letters, is there
a wild card for the linked file path that can be used instead of refering to
a drive letter? Something like %CD%\{directory name}\{filename.jpg}?

On second thought NG, I placed all the graphics in the same directory as the
database and made the directory reference relative. I tested it and it
worked fine. Thanks for the idea, you set me to thinking on the right path
(no pun intended!).

Obe

"NG" wrote:

Hi,

Application.CurrentProject.Path gives you the path of the current database,
you can start from there...
--
Kind regards
Noëlla


"Obe" wrote:

I have a large database with linked graphics as part of the records. The
database also has a data access page so users without Access can view the
information (reason for linked graphic files, since Data Access pages can
deal with OLE objects). I need to put the database on a CD, along with the
graphic files, for distribution (it will be run from the CD, not from a hard
drive so I can't have them install the files in the same path as I have
them). As individual computers may have different CD Drive letters, is there
a wild card for the linked file path that can be used instead of refering to
a drive letter? Something like %CD%\{directory name}\{filename.jpg}?