Access database error "Could not find file"?

Question

I have been using Access database as db of choice for a long time now and this is the first time I have run into 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 path to the db is defined in my web.config file thus:

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

Funniest part is that I am passing the connection string to some files without problem.

So, why is it different with this file?

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

Any ideas is greatly appreciated. I have been working on this issue since last night and googling hasn't provided any solutions.

Check your code with a debugger. Stop where you open the connection and verify the connection string used. — Steve
– Steve, Commented Jan 25, 2013 at 16:05
Are you using any table prefixes in your insert statements? Insert into dbo.someTable ... — John Koerner
– John Koerner, Commented Jan 25, 2013 at 16:12
@John, God BLESS you. I was! Sorry didn't mean to lie. I removed them but apparently in midst of frustration, I snuck it back in there without knowing it because I was trying everything. Thank you very much sir. Very nice catch. I don't know how you give credit here. — Chidi Okeh
– Chidi Okeh, Commented Jan 25, 2013 at 16:31

John Koerner · Accepted Answer · 2013-01-25 16:36:53Z

12

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

INSERT INTO dbo.someTable ...

Remove the namespace and it should correct the issue.

answered Jan 25, 2013 at 16:36

John Koerner

38.2k8 gold badges93 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chidi Okeh Over a year ago

Thanks again. I was going to demo this app by 1pm. Now, it is possible.

Collectives™ on Stack Overflow

Access database error "Could not find file"?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related