[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access 2007 and linked SQL database

Posted on 2011-03-25
4
Medium Priority
?
410 Views
Last Modified: 2012-05-11
I'm using Access 2007.   It's linked to a SQL server database.  Where/how can I determine the database, and Where/how do I change it?
0
Comment
Question by:HLRosenberger
  • 3
4 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35214995
<Where/how can I determine the database>

In the Navigation Pane, hover the mouse pointer in any of the linked tables from the SQL server and you can view its connection string . You can find there the name of the database as well as the sql server.

<Where/how do I change it?>

Altering the table structures must be done in the SQL Server.

Sincerely,
Ed

0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 35215131
When I hover over the table name, all I get is the table name. Also, I did not mean I wanted to change tge structure - I want to change the linked database.
0
 
LVL 1

Accepted Solution

by:
HLRosenberger earned 0 total points
ID: 35215418
I found it.   It's under Server->Connection info.
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 35252705
I found the answer myself.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

868 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