Any chance Access is defaulting to opening the db exclusively?
I am using VS 2008 Professional and connecting to an Access 2003
database. I have converted my app from VS 2003 to VS 2008. I have
kept all the OleDbDataAdpaters. When designing, I like to have both
VS and Access open, so I can see if my SQL queries and other code load/
edit/append/delete the data correctly.
The problem I am having, is once I open Access, I can no longer edit
any of my database settings in VS. Examples:
In VS I open the Server Explorer, and see the database I am using. I
double click on it, and I get the error message nspecified Error
In VS I try to add a DataSource. In the Data Source Configuration
Window, in the Choose a Data Source Type pane, I select Database and
click on Next. When I see Choose Your Data Connection, I select my
database, and I get ailed to open a connection to the database
nspecified Error Check the connection and try again.
In VS I try to configure the OleDbDataAdpater, I right click on it and
get the Data Adapter Configuration Wizard window, in the Choose your
Data Connection pane, I select my database, and I get ailed to open
a connection to the database nspecified Error Check the
connection and try again.
If I run/debug my app, the data loads just fine. So I know the data
is not messed up, and the connection is OK. I just have problems when
I am designing in VS 2008 and after I have opened Access 2003. If I
close Access, the problem does not go away.
To get the problem to go away, I need to :
load a new project,
Add a new Data Source to the new project,
re-open my project.
What is happening? Is there a better way to esetVS ?