Jim Hewson
JHewson at karta.com
Wed Jan 29 15:57:00 CST 2003
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