>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 connection at 1 to 10 megabits per second a possible. That is a 2300 to 4600 times increase network bandwidth performance 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 file share 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.

Hi Leland,

To be honest, I'm not sure, I understand, what you're talking about. I haven't yet tried anything on the server. So far, I tried some simple stuff on my local machine, where I have SQL Server and IIS installed (Windows 2000). I haven't also tried this sample yet, just peeked into the code and noticed, that this class requires connection to be opened the whole time...

BTW, an unrelevant question (I tried to ask Joe, but he didn't give me anything (in fact, he didn't give me a single piece of code yet except for the .sql for weekly updates)). I don't know, what should I use as a connection string to SQL Server. I've created a system DSN and use it, but AFAIK the right way is to use connection string, correct? If so, could you please give it to me, because I didn't come across it yet in the sites I visited so far and I'm a little bit tired of all this digging...
=======================================================
Tom pointed me out to this site, where I can download some goodies...

============================================================
Anyway, in this particular moment I'm struggling with completely different thing, precisely, Word :)
Firstly I found, that I can not have multiple headers across the document, then I found, that I can not insert Visio diagram to look right in Word (well, I can insert an icon of Visio, but not the diagram to be correctly formatted). This is all getting on my nerves...

UPDATE Joe just sent me a Word with Visio diagram inserted correctly, so at least one problem is solved.
(I just had to group the objects together - but I didn't know this trick).