MIKEV
asked on
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!
- 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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's it, thanks!
ASKER
- 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! :)