How to reset a linked table

I have an Access (2003) database.  It contains a linked table to an SQL server.  This has always worked until recently when we changed the address of the SQL server.  Fine.  I open my Database and:

- Linked Table Manager (one shows up, address is 'SQL' (old address))
- I put a check beside it and click OK.
- I get a login failure, fine.
- I enter 'sql.mydomain.com' (the new sql address) and click ok.
- It says linked tables were updated successfully.
- Double click the linked table, 'Login failed for user...'

grr...

- Linked table manager.
- The address for the linked table says "SQL".  wth?
- Repeat the process, nothing changes.

This procedure seems logical to me, why won't it save any changes I make?
thx!
MIKEVAsked:
Who is Participating?
 
grayderekConnect With a Mentor Commented:
Have you got service pack 1 loaded?  I have had no end of problems until SP1 loaded
0
 
MIKEVAuthor Commented:
After playing around some, I'm at this point:

- Linked table manager
- Check the connection
- Hit ok
- "Linked tables were updated successfully"

It's now not prompting me for a new location.  Don't ask me how this happened.

What's up with this nutsy thing?
Thanks! :)
0
 
MIKEVAuthor Commented:
That's it, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.