Jim Hewson
JHewson at karta.com
Wed Jan 29 16:35:01 CST 2003
Liz, This might work... I'll try it tomorrow. Thanks, Jim -----Original Message----- From: Liz Doering [mailto:liz at symphonyinfo.com] Sent: Wednesday, January 29, 2003 4:14 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Linking Tables manually Jim, If you know the path to the client's BE, one way to do this is to map a drive locally to duplicate the client's drives, move the BE to the local 'client' location, link the FE and BE locally with the linked table manager, then (zip and ) FTP everything to the client. When they open up the files, they are already linked, with no effort on their part, and very little effort on your part. Liz Doering Symphony Information Services 212 3rd Avenue North Minneapolis, MN 55401 612.333.1311 liz at symphonyinfo.com www.symphonyinfo.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Wednesday, January 29, 2003 3:57 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Linking Tables manually Drew, That worked... but... What I would like to do, is relink to the BE without being connected to BE location. IOW: set the path to the BE in the FE, FTP the FE to the client, and have it work! Is that even possible? If not, using your solution, I could have the client "setup" by using an update form. Thanks, Jim -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Wednesday, January 29, 2003 3:30 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Linking Tables manually Copy the text in the attachment into a module. Then from a Macro or Event put fRefreshLinks. Drew -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Wednesday, January 29, 2003 3:06 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Linking Tables manually Thanks Chris and Drew, I couldn't get either one to work, yet! Thanks again. Jim -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Wednesday, January 29, 2003 12:46 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Linking Tables manually http://mvps.org/access/tables/tbl0009.htm I wrote a little function that can be called from a macro, which just prompts the user for the BE location (with a file open dialog). It is all with code from the Access Web. (It made a semi-daunting task take about 2 minutes to develop...hehehe) Drew -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Wednesday, January 29, 2003 9:34 AM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Linking Tables manually Folks, New FE and BE for a client. I can use FTP to get the files to their network. I know the network path from the FE to the BE. I also know that the MSysObjects table cannot be edited manually. Is there a way to update the links without using the Linked Table Manager at the client's site? Thanks, Jim _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd