Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\DataBase.accdb'.

Question

0.00/5 (No votes)

See more:

I`ve connected an web page with access database, when I try to add a new record, I get this error:
(Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\DataBase.accdb'.)

note: my data base is already in App_Data folder.

and when I copy db file into that path, any inserting will be in that path not in the one in App_Data!!

how to fix it to keep changes only in the original database ?

Posted 16-Dec-12 1:24am

conanzz

Add a Solution

Comments

[no name] 16-Dec-12 7:29am

Please first rebuild your solution...

conanzz 16-Dec-12 7:32am

I did, got the same error

[no name] 16-Dec-12 8:13am

ok clean it and rebuild...

conanzz 16-Dec-12 8:17am

no use, can u tell me, should I keep a copy in that path: devserver\10.0\.. ?
or just stick with that data base in App_data ?

conanzz 16-Dec-12 8:23am

here is my code: http://img856.imageshack.us/img856/9102/1216201242021pm.jpg

5 solutions

Solution 1

The message is quite clear, you are trying to use a path to a file that does not exist. Your error is most likely because you are using a relative path for your database in your connection string (.\DataBase.accdb). Change your path to the correct location of your database and try again.

Posted 16-Dec-12 2:50am

Richard MacCutchan

Comments

conanzz 16-Dec-12 8:53am

well, you`re right, It`ll work when I keep the full path which is
C:\Users\Administrator\Documents\Visual Studio 2010\Projects\WebApplication5\WebApplication5\App_Data\DataBase.accdb

put I want to keep it portable for my teacher, I`ll send it to him.
dunno what to call this situation :(

Richard MacCutchan 16-Dec-12 10:02am

If you want to make it portable then you need to add some extra code to locate the file at the start of the application; see this link for more information.

Solution 3

VB

Source=|DataDirectory|\MyDB.mdb"

Solved it :)

Posted 22-Dec-12 4:20am

conanzz

Solution 4

Remove namespace [dbo]<tablename> (remove dbo) from the queries you are using. I removed it and it worked. The namespace redirects the connection to the shared folder of Microsoft

Posted 11-Oct-14 4:55am

offlineplanet

Comments

CHill60 11-Oct-14 12:03pm

dbo with Access? As you can see from the solution posted 2 years ago it was a connection string problem.

Solution 5

follow the path given and copy your database file(like abc.accdb) their .it will work

Posted 28-Nov-16 23:55pm

Member 12876507

Updated 29-Nov-16 0:15am

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

conanzz · Accepted Answer · 2012-12-16T02:56:00

Solution 2

Thanks, been solved by this path String:

HTML

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DataBase.accdb"

Posted 16-Dec-12 2:56am

conanzz