DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    VB Foxpro Query failure

    We have an application that connects to a Foxpro database. Another company sends us the databases and with their latest release, we're now having problems. Here are the relevant parts of the code.

    Public db As Database
    Public rs As Recordset
    Set db = DBEngine.Workspaces(0).OpenDatabase(Drive & "\" & databasePath & "\" , True, False, "FoxPro 3.0")
    Set rs = db.OpenRecordset(sSQL)

    We get the following error upon trying to open the recordset.
    The Microsoft Jet database engine could not find the object 'TABLENAME'. Make sure the object exists and that you spell its name and the path name correctly.

    We're using VB 6.0 with the latest Service Pack. Foxpro 6.0. DAO 3.51 is included as a reference in the VB project.

    I've verified that the table does exist at the path specified. The query is correct. I've opened Foxpro and run the query and the correct results are returned.

    Thanks for any help.

  2. #2
    Join Date
    Sep 2006
    On further investigation, the table names in the database have changed. They are now 11 characters long. When I change the table names back to what they were on the old versions, our code works.

    What needs to be updated to use longer file names?

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 05:24 PM
  2. Replies: 1
    Last Post: 04-07-2003, 10:03 AM
  3. They created J#, why couldn't they do VB#?
    By Thomas Eyde in forum .NET
    Replies: 290
    Last Post: 12-22-2001, 02:13 PM
  4. Replies: 1
    Last Post: 08-09-2001, 07:37 AM
  5. Re: VB or Powerbuilder?
    By Jean-Yves in forum Enterprise
    Replies: 3
    Last Post: 06-01-2000, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center