Error accessing database "Could not find file"?

I have been using Access database as a db to select for a long time and this is the first time I came across the following error message:

Could not find file 'C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\dbo.mdb'

      

First, I don't have a db called dbo.mdb.

Second, the db path is defined in my web.config file like this:

<connectionStrings>
<add name="cingconstrng" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\Roster\App_Data\AllStars.mdb" providerName="System.Data.OleDb" />
</connectionStrings>

      

The funny thing is I am passing the connection string to some files with no problem.

So why is this different from this file?

Is it because I am inserting records into db along with this file?

Any ideas are appreciated. I've been working on this question since last night and googling hasn't provided any solutions.

+3


source to share


1 answer


You can see this behavior if your SQL statements use namespaces:

INSERT INTO dbo.someTable ...

      



Delete the namespace and fix the problem.

+10


source







All Articles