SQL Database Diagram not showing up as an access object

  • Thread starter Thread starter Massinova
  • Start date Start date
M

Massinova

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.

Suggestions?
 
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
(French)
 
Back
Top