Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Database Diagram not showing up as an access object

Status
Not open for further replies.

Massinova

Technical User
Jan 12, 2005
23
US
I have a question as to what would prevent a Database Diagram (SQL 2005 database) from displaying as an access object in an ADP.

History: Our office is in the process of upgrading/migrating SQL 2000 databases from one network server to another network with SQL 2005. I’ve moved two databases so far. All the permissions are identical for both databases. The first database came across without a hitch and all the objects are visible in an Access ADP. However, when opening the second databases separately in its own Access APD, the Database Diagram will not show up as an Access object.

So far, I have gone as far as deleting and reattaching the second database, and rebuilding the database diagram on the SQL server side, but still am unable to get it to show up as an Access object in an ADP.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top