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?
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
HLRosenbergerConnect With a Mentor Author Commented:
I found it.   It's under Server->Connection info.
0
 
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 the answer myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.