• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Access 2007 and linked SQL database

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
HLRosenberger
Asked:
HLRosenberger
  • 3
1 Solution
 
MINDSUPERBCommented:
<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
 
HLRosenbergerAuthor Commented:
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
 
HLRosenbergerAuthor Commented:
I found it.   It's under Server->Connection info.
0
 
HLRosenbergerAuthor Commented:
I found the answer myself.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now