How to reset a linked table

Posted on 2004-10-01
Medium Priority
Last Modified: 2006-11-17
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...'


- 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?
Question by:MIKEV
  • 2

Author Comment

ID: 12203628
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! :)

Accepted Solution

grayderek earned 800 total points
ID: 12208853
Have you got service pack 1 loaded?  I have had no end of problems until SP1 loaded

Author Comment

ID: 12227806
That's it, thanks!

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question