current drive (A2K)

Topic

New Reply

I have a database my boss wants to run from a cd
the problem is there are several links to tables and images not in that database
and the cd may be a different drive letter on different machines but he wants to be able to run it from any machine
is there any way to put the drive letter the database is running on into the code in that database when the database opens up
TIA

Reply | Quote

Replies

In the code use CurrentProject.Path to return the path for the current database or CurrentDb.Name, which returns the full path, including the name of the database file. Links to images and tables that are not in the database or on the CD won’t work unless they just happen to be in the same place on every machine or unless they *are* on the CD and are relinked in code when the database is opened. Unfortunately, the database on the CD is going to be read-only, so I suspect that you won’t be able to relink tables on the fly.

Reply | Quote

Thanks Charlotte
I’ll give it a try later just to see if it will work with a cd
the database will only be used for showing the types of
data we record. So the read only should not be a problem

Reply | Quote