SQL user's schema

Thread is closed for posting
1 posts, 0 answers
  1. kultman
    kultman avatar
    35 posts
    Member since:
    Sep 2006

    Posted 16 Jul 2009 Link to this post

    I created user and defined user mapping to the databasen, and all other applications could use this user to access the data.

    I went on to test OpenAccess and tried to load the schema but nothing was found. After a while with debugging I found that the SQL user had a default schema set to the username. Chanced that to dbo and all tables were found...

    Just a tip, so someone else with the same problem doesn't waste hours debugging :)

Back to Top