Hi Nadya,

It appear the VBA script is using recordsets probably with a OLE DB provider. I tried MSDE 7.0 about two years ago using VFP 6. At that time I placed an activeX Grid on a form. I downloaded the HOWTOs from the MSDN web site and went through the example provided. I imported all my Software - Master (TM) tables to MSDE using the MS SQL database admin GUI provided in Visual Studio 6.

I was impressed favorable with the results. The recordset bound into the back-end tables just like in Visual FoxPro. I was able to navigate up and down the grid using recordset command like next, previous, etc. However, there were a few disadvantages.

The performance of the recordset was considerable slower than the performance I have come to expect using Visual FoxPro. Also, the ActiveX control was very limited in properties and method and left no way to satisfactory verify entries.

The idea of being disconnected from the database was born out of necessity in a time when modem speeds were 120 to 240 characters per seconds (e.g. 1200 to 2400 baud rates). Today high bandwidth connections at 1 to 10 megabits per second are possbile over TCP/IP, so a time when the front-end app binds into the back-end server is probably not far off. It would be fun to watch everything come full circle where a VFP like file/share method of connecting to the database was once again the perferred method.

In the mean time you could try a connection over TCP/IP where the front-end recordset-VBA, cursor-VFP, array-Perl, etc is synced with the back-end. If you have this kind of connection speed you might give it a try. I would love to try a VPN connection using Visual FoxPro to make a native file/share connection over TCP/IP just to see what performance would be.