>>Can I write a true client server app using ADO 2.5 and Access. By this i mean 1. the Access database is on a remote server 2. Clients are able query the database using ado. 3. Just the requested records are returned and not the entire database.
>>
>>This app is not big enough to invest in SQL Server, hence the use of Access. Can anyone help ???
>
>1. Yes no problem
>2. Yes no problem
>3. You have to use a ActiveX component (DLL or EXE) on the remote server that has the database. This component must contain all interactions to the database and can return recordset containing your data only. The entire database will be passed from the mdb file to the ActiveX component but since it is on a single server, your network won't take the load.
Christopher, have you considered MSDE? It's a free scaled down version of SQL Server, cannot take many users but it does process your database requests on the server so the entire table you are querying is not passed to the client.
George