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
|
|||
|
|||
Links to tables are broken after I copy new frontend to clients
Have backend on server. Frontend copied to 10 clients. Worked fine until ...
I copied an updated frontend to the clients. Somehow, the links to the backend were broken. To fix, I relinked the tables on each client to the backend. (Must be a better way) Is there a way to maintain the table links after I copy new frontends to the clients? |
#2
|
|||
|
|||
I see this problem when the user's ODBC, or path, is different. Especially
if you are linking through a Networked drive. Try setting your link up using My Network Places (Windows2000). This will create the link with the true network path name. (ie. \\ServerName\ShareName\Folder\DataDBFile) HTH Sharkbyte "jsccorps" wrote: Have backend on server. Frontend copied to 10 clients. Worked fine until ... I copied an updated frontend to the clients. Somehow, the links to the backend were broken. To fix, I relinked the tables on each client to the backend. (Must be a better way) Is there a way to maintain the table links after I copy new frontends to the clients? |
#3
|
|||
|
|||
Quote:
|
#4
|
|||
|
|||
jahoobob wrote:
jsccorps Wrote: Have backend on server. Frontend copied to 10 clients. Worked fine until ... I copied an updated frontend to the clients. Somehow, the links to the backend were broken. To fix, I relinked the tables on each client to the backend. (Must be a better way) Is there a way to maintain the table links after I copy new frontends to the clients? Place the Frontend on the server too. Then let each person shortcut to the FE. You make changes in the one db and they all continue along. They will need to close their shortcut and you will need to set them up with appropriate security on the server that allows them to open the FE at the same time. Terrible advice. Exactly the opposite of how a multi-user app should be set up. Every user should have a separate (local) copy of the front end file. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
broken links message still popping up | GJR3599 | General Discussion | 1 | March 30th, 2005 01:36 PM |
Broken links to slides within the presentation | Bob | Powerpoint | 4 | February 3rd, 2005 06:36 PM |
Copy Multiple Tables with Relationships | dang nguyen via AccessMonster.com | Running & Setting Up Queries | 3 | December 7th, 2004 01:22 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |