>I am using VFP 5.0 and have a table with approx 500,000 records in it. I have made this available over our network (NT4) for use by other users who use Access 97 and link to it with ODBC. How do I make Foxpro act as a sever program and process the requests on the server rather than back and forth across the network ?

You want to make what was called with 5.0 an AutoMation server. However, it would require you writting code in VBA to call methods of the automation server rather than having access do the work.

This means, you would have to have a method in your VFP automation server to retrieve that data.

The other idea is to have a general 'do' method in the automation server that you just send a query from access to... FoxPro would run the query then return the results. Of course, VFP is limited in what can be passed. I think you would want to move to VFP 6.0 so you can create and pass ADO recordsets.

BOb