SQL Database Diagram not showing up as an access object



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.


Sylvain Lafontaine

Maybe a problem with the schema (or owner for SQL-2000) used? ADP doesn't
seem to like it very well when you use something else than dbo as the schema
(or owner for SQL-2000) for the objects.

Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question