Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenTables - file does not exist error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00240606
Message ID:
00240849
Views:
25
One way to handle this is to create an ODBC connection to the folder that has the free table in it. Then when you add the view utilize the connection you create.

You can go to the ODBC manager in your control panel to set up the connection. Use the FoxPro drivers to make the connection, and give it a name. (You can do this from FoxPro as well by creating a new connection and selecting the New Data Source button, which starts the ODBC manager.)

From the data tab in your Project manager create a new connection using the name of the connection you just created in the ODBC mananger.

After you create the view make sure you make it updateable if you plan on writing data to the table.

HTH

>I have an application that I recently needed to move one of the tables out of >the dbc and make it a free table. If I run the app on a network with the free >table in the same directory as the .exe and a data dir below with the .dbc, >all is fine. If I move the .exe local and leave the free table and data folder >on the server, I get a "file does not exist" error during the OpenTables >method of the form's data environment.

>The form's data environment has a view which uses the free table. When a view >uses a free table, how does it find the table? I have tried to change the >default dir to point to the network folder and also added the network folder >to my path, but in both cases, I still get the error. All views in the .dbc >that are based on non-free tables seem to be working fine after moving the >.exe local.

>Any help is greatly appreciated.

>Kind Regards,

>Mat
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform