By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Access ODBC change

P: n/a

Hi,

I have a front end ms access 2003 and back end ms sqll 2000 server. I
have many tables, views linked to front end. I am going to change the
server hardware and new server going to have diff DNS name. Any easier
quick & drty way to update Access ODBC table/views/objects links
rather then deleting them all and putting a new link with new ODBC dns
name?
Is there an easy way to change..like instead of pointing to server1,
now point to server2?

Thank you,
hj

Feb 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hitesh Joshi wrote:
Hi,

I have a front end ms access 2003 and back end ms sqll 2000 server. I
have many tables, views linked to front end. I am going to change the
server hardware and new server going to have diff DNS name. Any easier
quick & drty way to update Access ODBC table/views/objects links
rather then deleting them all and putting a new link with new ODBC dns
name?
Is there an easy way to change..like instead of pointing to server1,
now point to server2?

Thank you,
hj
If you are using DSNLess connections then you will have to redo them to point at
the new server. If you are using a DSN set up in the ODBC Manager on each PC
then you simply change what server that DSN is pointing at.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Feb 17 '07 #2

P: n/a
Hitesh Joshi wrote:
Hi,

I have a front end ms access 2003 and back end ms sqll 2000 server. I
have many tables, views linked to front end. I am going to change the
server hardware and new server going to have diff DNS name. Any easier
quick & drty way to update Access ODBC table/views/objects links
rather then deleting them all and putting a new link with new ODBC dns
name?
Is there an easy way to change..like instead of pointing to server1,
now point to server2?

Thank you,
hj
Hitesh,

Just change the host name in your DSN setup.

Azhar
Feb 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.