Solved

Access Database

Posted on 2012-04-13
3
181 Views
Last Modified: 2012-04-13
Hi

I have an access database that points to a sql databse, i want to point it to a different database. How do you edit the connection please..
0
Comment
Question by:ac_davis2002
  • 2
3 Comments
 
LVL 70

Assisted Solution

by:KCTS
KCTS earned 500 total points
ID: 37841552
Unlink the tables and re-link to the new data source
0
 
LVL 70

Accepted Solution

by:
KCTS earned 500 total points
ID: 37841561
... go to External Data - linked table manger, you can do it from there
0
 

Author Comment

by:ac_davis2002
ID: 37841586
Thanks!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 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

13 Experts available now in Live!

Get 1:1 Help Now