Thanks Leland. I have read each of your posts.
The deal is that I must create these small tables and then store them as a BLOB in SQL Server. A fat client accesses SQL Server over the Internet and downloads files stored as BLOBs in SQL Server that are intended for that location.
Software at the client site uses the VFP table to provide reference information for validation and for lists. So I must deliver a VFP table and I must store that table as a BLOB in SQL Server.
I thinking of doing something in memory similar to Stonefields Database product but perform all work in memory vice creating the file on a hard drive.
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net
If at first you don't succeed, then skydiving definitely isn't for you.