>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com