refreshing links to back end database via vb code

[swichman]

I am using access 2003 and wish to use a form on startup to relink a
back end to a blank front end. I am using the code posted at
http://www.mvps.org/access/tables/tbl0009.htm to try and accomplish
this. Specifically I am taking the network location and equating it to
strNewPath. The code seems to work fine and gives me a message box
that all tables were relinked, however the tables do not get relinked.
Any suggestions?? I appreciate any help.

 

[Douglas J. Steele]

What do you mean by "a blank front end"? Are you saying that there aren't
already linked tables in it?

The sample code to which you refer assumes that the linked tables already
exist, and changes where they're linked to.

 

[swichman]

What do you mean by "a blank front end"? Are you saying that there
aren't
already linked tables in it?

The sample code to which you refer assumes that the linked tables
already
exist, and changes where they're linked to.



Thanks Doug for the reply. I will try it with a back end linked as I
am running two back ends off of the same front end. It may be a good
tool simply to switch back end databases??? Do you know if this code
can handle linking to ODBC SQL server connection? I will soon be
uploading the back ends from our network to SQL server and am looking
for some code that enables a user to choose which project they want to
link up to upon front end startup. Do you or does anybody know if this
code exists?
Thanks for any help.
Sean

 

[Douglas J. Steele]

For ODBC connections, see http://www.mvps.org/access/tables/tbl0010.htm

Another alternative is not to use DSNs, but create DSN-less connections. I
show one way to do that at
http://www.accessmvp.com/djsteele/DSNLessLinks.html