>Hi,
>
>I am a having two applications Inventory and FA. Inventory
>is under Fox 2.6 dos and FA is under VFP 5.0. Customers
>are created from FA. Once the custmer is created in FA at
>the same moment it should be creatd in Inventory also to
>make the shipment.
>
> But the problem is if i open fox 2.6 database in VFP 5.0
>then the database header is changed? Which I can use in
>Fox2.6?
>
>Is anyone can help me?
>
>Warm Regards
>MMK

Nishit,

As you've seen in several replies the problem is not with the tables. You can play with free tables as you want in VFP. What I've found trickier is how to access the 2.6 data from your application.

I've used two approaches so far. Both end up building a view in your project DBC that will give you access to the 2.6 data.

In my first approach, I copy the 2.6 tables into a TEMP directory and build a local view on them. I generate the DBC code with the help of GENDBC or GENDBCX and save the view related code into a PRG, let's say Make_View_Customers, customizing its FROM clause:
lcPath = Some Function to build the path to your 2.6 data
Then: SELECT ... FROM &lcPath

My second approach is to get at the 2.6 data with a remote view. I first make a connection then build the remote view.

The approach you take really depends of your needs. The first is easier to maintain since everything is done in VFP. The second will work best if you maintain you data model with a thrid party tool like xCase.

José




. I save the path to the 2.6 tables at the time the user launches a preference screen and RUN