Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing Data Source

Status
Not open for further replies.
skippaNH

skippaNH

Technical User
Aug 1, 2001
18
US
Hi all,

How do I change the DSN that tables are imported from? This is for an Access 97 database.

Thanks in advance.
 
Sort by date Sort by votes
skipp,
Go into Tools|Add-Ins|Linked Table Manager. You'll find the functionality you need in there.

Tranman
 
Upvote 0 Downvote
skipp,

Do you want to do this as a one off, or redirect it regularly by code?

BGE
 
Upvote 0 Downvote
Just need it to refresh (or redirect) on time. The IP address was changed on the server of the data shource. Existing Access db would then error when trying to validate.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
214
SkipVought
S
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
736
Anthony343242
Anthony343242
TrekBiker
  • Locked
  • Question
Prevent new data being used when using Archive backend
Replies
0
Views
330
TrekBiker
TrekBiker
jjMedrano
  • Locked
  • Question
UNION ALL with Attachment data type 1
Replies
8
Views
204
Andrzejek
Andrzejek
puforee
  • Locked
  • Question
Best way to setup tables for multible related data sets
Replies
1
Views
155
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top