It is not quite that simple. First, your syntax is incorrect using the
forward slash /

Also, you need to fully qualify the path. "My Documents" folder is a
subfolder of your user name folder. For example, my user name folder is
DaveH, so to get to My Documents, the full path is:

C:\Documents And Settings\DaveH\MyDocuments

Also, the path has to exist. If it does not, you can use MKDir to create
the path. To determine if it exists, use the Dir() function.

--
Dave Hargis, Microsoft Access MVP


"Fox" wrote:

I want to split my db for other reason than to share with tons of people and
I need the backend on the local machine with the front end but in a
different directory. The db front and backend will be
distributed as a packaged solution to a singler user. The user will install
the access runtime as well as the db's.
When I try to split the db called My Jewelry Project and place the backend
in a folder called My Jewelry Data using this address //My Document/My
Jewelry Data/JeweryData.accdb
it will not find the location....even though the folder exists....

I've tried ~/bla bla bla and ~//bla bla bla and these links do not work
either.

So how do I split a db and have the backend on the same computer with a
relative path?
Thanks,
--
Foxy