[RESOLVED] Incorrect path to database
I just setup a new dataset for a new project. I then created a BindingSource and tableadapter to the form.
When I attempt to load,
Code:
Me.LkpDepartmentTableAdapter.Fill(Me._MasterBase1_0DataSet.lkpDepartment)
I get the following message
Quote:
System.Data.OleDb.OleDbException: F:\SiTech\SiTechPublishing\Projects\SiTechSolutions\MasterBase3.0\bin\debug\bin\debug\MasterBase1.0. accdb' is not a valid path.
I can see what the problem is, but am unable to fix it. The above string has an extra \bin\debug that does not exist. I have no idea where to go to correct that line and eliminate the extra \bin\debug contained in the line of code.
So where to I find that line and correct it? I have recreated the binding source and even the dataset a couple of times with the same outcome.
The location of the database. MasterBase1.0.accdb is located in the following directory.
Quote:
F:\SiTech\SiTechPublishing\Projects\SiTechSolutions\MasterBase3.0\Bin\Debug\MasterBase1.0.accdb
Re: Incorrect path to database
In my signature block is a link "I swear I saved my data, where'd it run off to?" ... it's not exactly your problem, but it is your problem... It should hopefully explain what the issue is and how to remediate it.
Normally when we see people with this problem, it's when they are losing data. this is a first for "moving" databases (which aren't really moving).
-tg
Re: Incorrect path to database
I had no lost data when I penned this, just an extra pair of directories. In my continued efforts to find and fix the issue I did manage to lose it all, as well as completely screw up my VB Solution/project. I am now in the process of recovering the data, what can be recovered, and it is looking like a new solution/project, using whatever is recoverable, and starting clean.
Damn. Why can't I just leave things alone and not tinker when I have no idea what I am doing? History does not teach.