I created a new MS Access project against a SQL Server 2008 database using windows based authentication. (UPDATE: Now using Login Credeitnals, same results though) I have some tables in the (dbo) schema and some I made in a (prj) schema.
In the access project itself, prj is not recognized but the dbo are. Looking at the access table list, the schema shows up in parenthesis after the table name [IE: WidgetTable(dbo) ]. I receive the following error anytime I try to open any prj table:
ADO error: Object '[myusername].WidgetTable' does not exist or is not a valid object for this operation.
Any dbo tables can be opened and used just fine. It doesn't recognize the prj tables as part of the prj schema and attempts to evaluate them as myusername.tablename
Things worth mentioning:
- Using MS Access 2003 format project file, on MS SQL Server 2008 (Updated: Just learned they upgraded it a few weeks ago, without my notification /sigh)
- prj owner was myusername, changed it to dbo but hasn't fixed the problem
Do I need to redefine all of my prj definitions to the (dbo) schema or does someone have a solution to this problem?
UPDATE: Received my login credentials finally, same problem except now there are parenthesis showing up that contain my network login name. Basically, its doing the same thing as before when I was using windows authentication, nothing changed. Permissions look fine unless I'm missing a finer detail... what am I missing, anybody out there able to replicate this problem???