Copying datbase with pictures into a cd

A

America

I would like to copy my database into a CD but everytime that the files move
the pictures do not display. Can I create a virtual path?
 
K

Kai Apel \(Berlin\)

what kind of pictures? try to make the path not hardcoded like "C:\my
Pictures\....". Here you can find a Function, that gives your the Pathname
of your Database:
http://www.access-home.de/htm/funktionen/fusga009.htm - is a german page
When you what have the pciture in your own Path, you can combine
DBP with any string, for example:
strPicturePath = DBPfad & "picture" you wold get the Pathname of the
Picturepath.
You also can use that:
DBPath= Left(CurrentDb.Name, Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name)))
and you will get the Pathname of you running database.

Greets

Kai Apel (Germany,Berlin)
 
Top