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 ???