My mistake, I should have underlined the word "server" to mean "remote" and NOT "local". My apologies.

Petras


>>Hi, I have come across the term "ODBC Server" several times in the VFP6 documentation. Can someone briefly explain whether:
>>a)Is it possible to create an ODBC server with VFP?
>>b)Using the "VFP Connection Designer", how do you specify the "ODBC Server" you wish to use.
>>
>>Thanks in advance
>>Petras
>
>Any data format that has an ODBC driver can become an ODBC server. This includes VFP, SQL Server, Access any DBMS worth its salt, and even other backends like Excel. ODBC is a mechanism that provides a common interface for all of these 'backends'. If you create an ODBC Data source from your database (or whatever) you can then access that data source from any application that is capable of opening ODBC datasources.
>So I have a database that was built in MS Access. I go to Start-> Settings -> Control Panel -> ODBC, and click add. I select MS Access Driver, and then give my data source a name, and locate the .mdb file. Done. I can now open VFP, open my VFP database, right click in the designer and choose connections. I click on Add, and select my new datasource from the list. I now have a connection to an Access database from VFP. With this, I can create remote views to access that data. This is the 2 minute client server tutorial. Any questions?