Drew Wutka
DWUTKA at marlow.com
Wed Jan 29 15:30:00 CST 2003
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: fRefreshlinks.zip Type: application/octet-stream Size: 4751 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030129/38841373/attachment-0002.obj>