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 :)