[AccessD] Linking Tables manually

Jim Hewson JHewson at karta.com
Wed Jan 29 16:20:00 CST 2003


Chris,

I did that, but nothing seemed to change.
I ran the code, but in the MSysObjects table, the path didn't change.
What am I missing?
Thanks,

Jim

-----Original Message-----
From: Chris Mackin [mailto:chris at denverdb.com]
Sent: Wednesday, January 29, 2003 4:08 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Linking Tables manually


Jim,

The code I sent earlier will do what you want, the two things you needed to
do were to modify the Connect String to reflect the actual path to your back
end .mdb file and make sure you had a reference to DAO.  Let me know if you
need help setting that up.

Chris Mackin
www.denverdb.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 2: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



More information about the AccessD mailing list