>I am a bit confused about ODBC. I want to change my application into a client server application so that I can place my database files on the server, in a directory which is not shared for obvious reasons. I then want those files only to be accessible using my client application, for which I want to use an ODBC connection. Is it necessary to upsize to SQL Server? Or can the ODBC connection be used directly for access?
>
>Thanks!
If you only want to place your database files on a server you can simply move your foxpro database and .dbf files to a network directory and access them from your application in this manner. In this manner you can use native VFP connectivity rather than ODBC.

You DO have the option of migrating to SQL Server. This decision depends upon your present and future circumstances:

          1) How much data are you working with?
          2) How much data will you be working with in the future?
          3) How many clients are accessing the application/data?
          4) How many clients do you predict will be using the application/datat in the future?

These are just a few of the questions you need to look into for that decision. Sorry for rambling but hope this helps.