Hey Jeff thanks for replying...
sorry to not have given enough info...

To split the DB I'm using the wizzard...and I'm trying to put a relative
link in the name file box....however it will only exept a server location and
not a local relative path like ../My Documents/My Jewelry Data/My Jewelry
Data.accdb....

This is a project software that I am developing for crafters like myself
that want to keep track of some information in regards to costs etc...

I Package the front end and back end in two seperate packages so that the
front end can be uninstalled if I have an upgrade I need to distribute and
then they do not loose thier data.
I have a backup and restore procedure that I got working great and would be
fantastic as then I would not have to split the db's however when I add the
ms runtime to the package the backup and restore doesn't work properly....so
I'm just trying to figure out a way so that they do not loose thier data if I
have an upgrade.
When the project db install the person does not have access to any views of
the tables ect....
The way you suggest to split the db....will this allow for a relative path
and also will the person installing from the package have to link the
table....they will not have this available to them.

Thanks,
Janet
Foxy


"Jeff Boyce" wrote:

You don't mention "how" you are trying to split the db.

One approach is to make a couple copies of the unsplit db, open one and
remove everything but the data, open the other (copy) and remove only the
data (i.e., tables).

You should be able to use Windows Explorer to "manually" copy the
tables-only copy (the "back-end") to what-ever directory you want.

Then open the front-end and link to the tables in that back-end, where-ever
you put it.

Does that work?

--

Regards

Jeff Boyce
Microsoft Access MVP


"Fox" wrote in message
...
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