open up existing database being used via sql server 2005

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

I want to open up a database that is currently being used by SQL Servr 2005.
How do I do that?

OR - can I get a copy of the Pubs database for Access 2007? That's the one
i'm trying to open up.

thanks,
Megan
 
Megan

First, you get the folks who maintain (?control) the SQL-Server installation
to give you permissions to the database.

Then you create an ODBC connection (data source name) to that SQL Server db.

Finally, you open an Access database in database view, use File | Get
External... | Link ..., and change the 'type' to ODBC to locate that new
ODBC/DSN you created.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top