Results 1 to 9 of 9

Database Diagrams help needed

  1. #1
    RayMilhon is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    949

    Database Diagrams help needed

    I keep getting this error every time I try to go into the database diagrams. Click image for larger version. 

Name:	Databasediagramerror.jpg 
Views:	31 
Size:	29.3 KB 
ID:	26157 The problem is that the database does have an owner so how do I correct an error that doesn't exist.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,002
    If you're still trying to fix this I suspect it's more to do with the database diagram objects rather than the database owner. Every time a database is created it the 'ownership' is inherited by the users's information (at least I can't find any database in my reach without an owner). You can check the ownership by right clicking on the database, selecting properties, going to the DETAILS tab. If you have an owner listed in that screen it has to do with the database diagram tools.

  3. #3
    RayMilhon is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    949
    As I stated the database does have an owner. I know it's the database diagram tools I need help on how to fix this

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,002
    How is your database constructed, are the tables in SQL server and the user interface is in access? or are the tables also in MS access?

  5. #5
    RayMilhon is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    949
    tables are in SQL Server and the user interface is in access.

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,002
    http://blog.sqlauthority.com/2012/02...a-valid-owner/

    this is a SQL problem, not really a MS access problem then

  7. #7
    RayMilhon is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    949
    Which is why I posted it on the SQL Server page of this forum

  8. #8
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,002
    I didn't state otherwise, just clarifying because it wasn't even clear that you were using SQL until post 5 after two other exchanges. I then provided a link to a similar thread to try and help solve it.

  9. #9
    RayMilhon is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    949
    You're right rpeare, I didn't realize that, I assumed that since I posted in the SQL Server forum it was taken for granted. I can see now where it was confusing. my apologies.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. relationship diagrams help
    By trexsteve in forum Database Design
    Replies: 1
    Last Post: 06-16-2013, 10:06 AM
  2. Creating Block Diagrams from Access Database
    By SasQuach in forum Programming
    Replies: 0
    Last Post: 01-18-2012, 12:36 PM
  3. Dynamical diagrams
    By Maddin in forum Programming
    Replies: 1
    Last Post: 06-23-2011, 02:29 AM
  4. database help needed
    By handsome1855 in forum Database Design
    Replies: 0
    Last Post: 03-14-2011, 07:25 AM
  5. New database - help needed please :)
    By tonypony in forum Database Design
    Replies: 1
    Last Post: 07-29-2009, 03:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums