C#.NET path error. Please guyzz. its urgent

Question

I ve created a C#.NET Project in my PC. I used MS Access as Database. When I tried to copy and run the same project in other PC's its showing path error. I tried using Application .StartupPath() in my connection string path. But while using it the database is empty as soon as i stopped running the project. Somebody please help me.

Mukesh Kumar · Answer

Hi It seems that your database is not accessible to your project using the connection string which you are providing. .. chech this point Thanks

Sujeet Suman · Answer

Hari have you gone through my reply?

Mukesh Kumar · Answer

Hi This issue comes when the path does not exists on the system. so please check that the path which you are providing for first system is exists on other system or not. Hope this will help you. thanks

Sujeet Suman · Answer

Hari as per my understanding & experience when we are developing a software then always we should think dynamically. Write the connection string like below: - Data Source = MS-Access_File.accdb  name = myConnectionString/> Use in your application like below: - using(OdbcConnection myConnection = new OdbcConnection()) { myConnection.ConnectionString = myConnectionString; myConnection.Open(); //execute queries etc } Create a new folder like MYAPPLICATION & put your MS-Access file & EXE in that folder. So your MS-Access file & EXE will be in same directory . When we are developing a software then always we should take care of standards. If this is helpful for you then please accept my Answer.

Srinivas Rao · Answer

connection.Connection String=@Provider=Microsoft.ACE.OLEDB.12.0;Data Source= give the path name here ;Persist Security Info=False;

Hari M · Answer

string Connstr = @Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Hari\Documents\Visual Studio 2013\Projects
ewLIB\Lib2\Mine.accdb; my path is like this. but when i tried to copy and run this project in other PC. I need to change the path according to that PC. is there any method to avoid doing that?

Hari M · Answer

Yep. Sujeet. I ve gone through it. I used it in my project. first time it is running fine. but when closing the application and restarting  all the data stored in database during the first time is not available.

Hari M · Answer

I can't quite understand it. can u please explain me. please

Srinivas Rao · Answer

Provider=Microsoft.ACE.OLEDB.12.0;Data Source= C:\myFolder\myAccessFile.accdb ; Persist Security Info=False; mention the path of database u created [eg..as I mentioned above] can u try this...