Hi Dan,

I'm using VFP as the front-end and MS SQL Server as my shared database. I'm using the updated Flash Codebook as my framework.

I use VFP tables as lookup tables to reduce network traffic. I'm using remote views to read and write to MS SQL Server.

You will have to learn some MS SQL Server. But it is not that difficult. There is a beta version of SQL Server 7.0 that you can download (100 mb) and run it on a Win 95 workstation to give you some practice. It installed and ran on the first attempt.

You could probably contract out the setting up of the database on your server and gradually learn what you need to know.

Good luck,

Paul


>Hello all,
>
>I'm new to client/server, so forgive me if this question is stupid.
>
>I’m developing an application that will access about 3-4 Million in the primary table and lots more in secondary table. I have about 20 users local on a 100Mbt Netware server for which I would prefer direct data access or local views, but I have 5 that access the data over T1. Obviously they will need C/S. Must I have all users in a client/server? I see some products like Advantage Database Server will access Foxpro native files. Can I have some users access the files remotely through C/S and others access the same files locally? I assume not, but just checking.
>
>Any comments on Advantage Database Server would be helpful as well.
>
>Obviously, I’m trying all sorts of contortions to avoid having to learn and maintain an Oracle or SQL server database. If they'd just let me upgrade to T3 ...
>
>Thank you in advance for your comments.