Connecting to Tables 1

[fabby1]

Hi

I currently have 6 tables that reside in SQLServer. I connect to them through an ODBC connection created on the machine then I have Linked to the table in Access.

Is there away that I can create the links in VBA, so that I don't have to create the ODBC connection on the users machines.

Thanks

Phil

 

[lupins46]

Look here:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

 

[fabby1]

Thanks for the link, answered my question

Thanks

 

[LLBP]

This link doesn't work anymore. It sounds exactly like what I need. Can anyone give an updated link or other solution? I have a replicated database. The linked tables that existed when I created the first replica are replicated but new linked tables are only local. I have to create the new links on the other replicas as local tables. I'm adding new ones as the project progresses and the replicas are growning too. I'd like to create the links from code so as not to worry about maintaining the replicas.

 

[lupins46]

I wWasn't around last week I'm afraid.

http://www.accessmvp.com/djsteele/DSNLessLinks.html