Changing ODBC Data Source for linked tables

[Tony Spratt]

Hi,

I have a project which has an Access 2003 front end with all the data in SQL
Server 2005 linked tables. When the project is moved from dev to UAT or UAT
to live, the linked tables need to be relinked and the appropriate ODBC data
source selected. I would ideally like the application to pick up the name of
the DS automatically from the .INI file (that bit I can do already) and
relink the tables programmatically (that bit I can't). Is this possible? And
if so does anyone have any pointers to get me started?

Thanks,

Tony.

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/tables/tbl0010.htm at "The Access
Web" is enough to get you going.

You could also consider going DSN-less. I show one approach at
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

 

[Tony Spratt]

Doug,

Thanks for that - I'll look the links up and see how I go.

Cheers,

Tony.

 

[aaron.kempf]

uh.. Moving to Access Data Projects would make your life easier.. and
your users happier.

Running SQL Server through Jet is like trying to pick up a metro bus
and carrying it home with you everyday...
It's just pointless to use Jet.

Sorry-- but it's been that way for a long time.

Access Data Projects give you a single database-level connection,
under File, Connection, ServerName + DbName.
It's much much simpler architecture... and it doesn't involve writing
mountains of code.

Linked Tables are the worst architecture in the whole wide world.

-Aaron

 

[Tony Toews [MVP]]

I have a project which has an Access 2003 front end with all the data in SQL
Server 2005 linked tables. When the project is moved from dev to UAT or UAT
to live, the linked tables need to be relinked and the appropriate ODBC data
source selected. I would ideally like the application to pick up the name of
the DS automatically from the .INI file (that bit I can do already) and
relink the tables programmatically (that bit I can't). Is this possible? And
if so does anyone have any pointers to get me started?

Please ignore Aaron's posting as Aaron's answer to just about every
question is ADPs. No matter how appropriate his response.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/