VB Foxpro Query failure

[3Tiggers]

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.

[3Tiggers]

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?