Your problem may lie in the pathing involved with the My documents directory structure. If you are developing on your machine, you directory structure may be something like this and your installation directory may be different. example:
C:\Documents and Settings\John Doe directory\My Documents
your target may be:
C:\Documents and Settings\Willie Bethere directory\My Documents

What I do is link in the tables from the back end once I have installed the front and back ends. That way it points via Microsoft directory structures to the right pathing.

Hope this helps.



Fox wrote:

Split db and have backend on local PC
04-Oct-09

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

EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown ListBox and XML Databinding
http://www.eggheadcafe.com/tutorials...n-listbox.aspx