Results 1 to 3 of 3

Thread: [RESOLVED] Incorrect path to database

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Location
    Oregon City, Oregon
    Posts
    705

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

    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.
    F:\SiTech\SiTechPublishing\Projects\SiTechSolutions\MasterBase3.0\Bin\Debug\MasterBase1.0.accdb

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Location
    Oregon City, Oregon
    Posts
    705

    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width