Hi John,
Thanks to you, John, after getting a good sleep I was able to figure out how
to make the code work. I was trying to link to a file that had been moved to
the folder the database was in but I had copied the file to the wrong
folder. Doh!
Kind Regards,
Patrick Wood
Microsoft Access MVP
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers:
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Friday, August 24, 2012 7:15 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Changing links to multiple back ends
Pat-
Sure you can!
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Patrick Wood
Sent: Friday, August 24, 2012 12:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Changing links to multiple back ends
Hi Glen,
You cannot do it with the RefreshLink method. I am not sure you can use code
to delete the existing TableDef and add a new one but it is very late and I
do not have time to test it now.
Kind Regards,
Pat
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Jumat, 24 Agustus 2012
RE: [MS_AccessPros] Changing links to multiple back ends
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar