Solved

How to reset a linked table

Posted on 2004-10-01
3
241 Views
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...'

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!
0
Comment
Question by:MIKEV
  • 2
3 Comments
 

Author Comment

by:MIKEV
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! :)
0
 
LVL 2

Accepted Solution

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

Author Comment

by:MIKEV
ID: 12227806
That's it, thanks!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now