Why use VB? VFP works just fine and data access and processing to the Fox tables will be much faster.


>We have an old system running FoxPro 2.5 For DOS. There is a need to exchange
>data with a MS SQL server (remote) real time. A program need to be developed to access both databases. I am thinking about using VB plus ADODB object in MDAC 2.5 to do the job. The FoxPro 2.5 database files are on a NT 4.0 server.
>
>I did the following test on a test manchine.
>1. Install FoxPro 2.5 on a NT 4.0 machine.
>2. Create ODBC data source on the same machine to the FoxPro database.
>3. Create a small Visual Basic Code using ADODB object and successfully access the table.
>
>My question is what will happen if other user are using the old DOS application
>accessing the same table files at the same time? Can I lock the table by using ADODB?
>
>Many thanks in advance,
>
>Dayang