Thank you. I will likely test it and post how well it does in about a week. Stay tuned. . .
JR
>Joy,
>
>I can't say much about the speed issue as my tables are not that large. OLE DB seems a bit quicker to me, but for my use the difference is tiny.
>
>However, I would caution you about an issue with VFP OLE DB and Crystal Reports 9: There is a bug in VFPOLEDB that causes it to crash when enumerating stored procedures under some circumstances. This is not a problem with CR 8.5 as it does not enumerate stored procedures, but CR 9 enumerates them under several circumstances. It is possible to turn off this enumeration in most places, but if you ever Verify the database links for any reason it may crash.
>
>This is not a problem for all databases, but it is unpredicatable. Both Jeff Southworth and I have had problems while testing CR9. In my case, the crash occures when I have a fairly large referential integrity procedure. Jeff believes his case is due to a large number of stored procedures.
>
>Hopefully Microsoft will have a fix for VFPOLEDB.DLL soon...
>
>...Jim
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488