Access-2007 DB in different folder - connection string?

Question

I have a small project with Access-2007 Database available in directory C:\SVHML_ERP\Data\SVHML_Management.accdb

Therefore my connection string is

SVHMLConStr = "Provider=Microsoft.ace.Oledb.12.0; Data Source='C:\\SVHML_ERP\\Data\\SVHML_Management.accdb'; Persist Security Info=False;"

But, it's simply adding the project directory to it's data source directory ....Iam getting the error like

OleDb Exception was unhandled : "Could not find file C:\Documents and Settings\Paraman\My Documents\visual studio 2010\projects\My_Applications\My_Applications\SVHML_ERPDataSVHML_Management.accdb

Does anybody can point me the mistake... Thanks & Regards Paramu

You want to add your accdb to your VS Project, am I right?

TuVi
– TuVi

2014-04-03 08:18:49 +00:00
Commented Apr 3, 2014 at 8:18 — TuVi
– TuVi, Commented Apr 3, 2014 at 8:18
Yes.. I wish to add to my project... thank you

Paramu
– Paramu

2014-04-03 08:24:59 +00:00
Commented Apr 3, 2014 at 8:24 — Paramu
– Paramu, Commented Apr 3, 2014 at 8:24

Paramu · Accepted Answer · 2014-04-03 15:20:24Z

0

I found the error because of SQL Server Database has been mistyped on Select Query... Therefore the connection string has not a problem...

After removing the SQl Server Database Name from Query, the path has cleared and works fine...

Thanks for all the helps & Valuable minutes

answered Apr 3, 2014 at 15:20

Paramu

6332 gold badges11 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Access-2007 DB in different folder - connection string?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related