Hi, Alcide.
If you are using Access 2003, then create your directory structure on your
hard drive and add the files, including the Access database file. Open the
database file and add the hyperlinks to the files in the relative directories
to the table. When finished, copy the entire directory tree to the CD. The
relative links will remain.
For example, if you had the following directory structure:
C:\Test\CDDirs
C:\Test\CDDirs\Data
C:\Test\CDDirs\Data\DirBelowDB
C:\Test\CDDirs\OtherDir
.. . . you could place files in the CDDirs directory and any of the
subdirectories below it, then place the Access database file in
C:\Test\CDDirs\Data and create hyperlinks to the rest of the files in the
CDDirs directory tree. You could then copy the CDDirs directory (including
all subdirectories) to the CD, and the hyperlinks in the database table would
still work when the database is opened on the CD. For example, the new
directory structure on the CD would be:
E:\CDDirs
E:\CDDirs\Data
E:\CDDirs\Data\DirBelowDB
E:\CDDirs\OtherDir
.. . . where the E:\ drive is the CD-ROM drive.
Bear in mind that running the database application from the CD will be much
slower than running it from the hard drive. If I remember correctly, earlier
versions of Access didn't process relative links in the same way, so if the
computer that is running the CD isn't using Access 2003, first test this
approach using a small test database file (with hyperlinks in the table) with
your directory structure (or a similar one) on a floppy disk to see whether
it works correctly. That way, you won't waste a CD if you're using CD-R's as
your media.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
