View Single Post
  #2  
Old October 4th, 2009, 05:37 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Split db and have backend on local PC

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