Changing ODBC Data Source for linked tables

T

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.
 
A

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
 
T

Tony Toews [MVP]

Tony Spratt said:
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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top