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.
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.