Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Database

Posted on 2012-04-13
3
Medium Priority
?
197 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 2000 total points
ID: 37841552
Unlink the tables and re-link to the new data source
0
 
LVL 70

Accepted Solution

by:
KCTS earned 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 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