How To Determine Database Home Directory

[Duck]

I am creating a client database in which I want to also store client
photos. The photos are stored in a subfolder of the folder in which
the database is created. How can I indicate in my VBA code which
populates the unbound image frame, the relative location of the
photos
folder (relative to folder in which the database is created). I want
to be able to move the database to a different folder on different
computers.

 

[Dennis]

CurrentProject.Path will give you what you want

 

[a a r o n . k e m p f]

keep your data in SQL Server and you won't have problems like this
you could always say 'select * from sysfiles'

 

[So Sorry For Poor Aaron]

keep your data in SQL Server

Him jailbird, don know nuttin else, don know how, neither, dumb as dry dirt.

 

[Tony Toews [MVP]]

I am creating a client database in which I want to also store client
photos. The photos are stored in a subfolder of the folder in which
the database is created. How can I indicate in my VBA code which
populates the unbound image frame, the relative location of the
photos
folder (relative to folder in which the database is created). I want
to be able to move the database to a different folder on different
computers.

Now by database do you mean the front end or the back end? Is this a
multi user system?

If a multi user system then the BE will be stored on a file server.
To get that you need to look at the tabledef's connect string.
currentdb.TableDefs("<table name>").Connect

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/