If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please Help?? Split Database - Refering to backend
Good Afternoon,
Is there a way of changing the path that the front end of a database uses to locate the back end? Basically I am having trouble because on some PC's the path to the backend is different due to naff network mapping...... Thanx in advance -- Regards Ashley Smart |
#2
|
|||
|
|||
Please Help?? Split Database - Refering to backend
There is a linked table manager in the Tools menu that allows you to relink
your tables. As an alternative, when you link, you can use the UNC path like: \\swanky\H$\Documents\Projects\Access\Garvey\WillP owerBE.mdb -- Duane Hookom MS Access MVP -- "A. Smart" wrote in message ... Good Afternoon, Is there a way of changing the path that the front end of a database uses to locate the back end? Basically I am having trouble because on some PC's the path to the backend is different due to naff network mapping...... Thanx in advance -- Regards Ashley Smart |
#3
|
|||
|
|||
Please Help?? Split Database - Refering to backend
I have actually used the UNC path for all tables apart from one, odd! And
that is my Switchboard how do I change it? -- Regards Ashley Smart "Duane Hookom" wrote: There is a linked table manager in the Tools menu that allows you to relink your tables. As an alternative, when you link, you can use the UNC path like: \\swanky\H$\Documents\Projects\Access\Garvey\WillP owerBE.mdb -- Duane Hookom MS Access MVP -- "A. Smart" wrote in message ... Good Afternoon, Is there a way of changing the path that the front end of a database uses to locate the back end? Basically I am having trouble because on some PC's the path to the backend is different due to naff network mapping...... Thanx in advance -- Regards Ashley Smart |
#4
|
|||
|
|||
Please Help?? Split Database - Refering to backend
Sorry, I'm getting lazy asking all these questions. Pretty simple really.....
Cheers -- Regards Ashley Smart "A. Smart" wrote: I have actually used the UNC path for all tables apart from one, odd! And that is my Switchboard how do I change it? -- Regards Ashley Smart "Duane Hookom" wrote: There is a linked table manager in the Tools menu that allows you to relink your tables. As an alternative, when you link, you can use the UNC path like: \\swanky\H$\Documents\Projects\Access\Garvey\WillP owerBE.mdb -- Duane Hookom MS Access MVP -- "A. Smart" wrote in message ... Good Afternoon, Is there a way of changing the path that the front end of a database uses to locate the back end? Basically I am having trouble because on some PC's the path to the backend is different due to naff network mapping...... Thanx in advance -- Regards Ashley Smart |
#5
|
|||
|
|||
Please Help?? Split Database - Refering to backend
Duane,
I want to split my db for other reason than to share with tons of people and I want the backend on the local machine. 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, Janet -- Foxy "Duane Hookom" wrote: There is a linked table manager in the Tools menu that allows you to relink your tables. As an alternative, when you link, you can use the UNC path like: \\swanky\H$\Documents\Projects\Access\Garvey\WillP owerBE.mdb -- Duane Hookom MS Access MVP -- "A. Smart" wrote in message ... Good Afternoon, Is there a way of changing the path that the front end of a database uses to locate the back end? Basically I am having trouble because on some PC's the path to the backend is different due to naff network mapping...... Thanx in advance -- Regards Ashley Smart |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Database Split Without taking my relationships to the BE | GAB | New Users | 2 | January 24th, 2006 05:59 PM |
Replicate or split database? | Brossyg | Database Design | 4 | September 2nd, 2005 01:12 PM |
Split Database: Keep Tables in single Access file or multiple files ??? | Will | General Discussion | 2 | August 24th, 2005 05:31 AM |
WTH? Split database ldb problem | Biggles | General Discussion | 3 | August 4th, 2005 12:08 AM |
Split Database Access over Network? | Roger Tregelles | General Discussion | 3 | August 2nd, 2005 03:06 PM |