I have to make an architecture desicion, any tips are welcome.
a) Accessing an MS Access-database on a NT-server directly through a DSN on the clients. (with ADO or DAO)
b) Writing a NT service application that gets requests from clients (through sockets) and uses ADO and DAO to do the searching and then returns the results back to the clients.
What are the consequences for performance, and do I have to use multithreading for option B?
(btw: most of the time, the database is only used to retrieve either a complete table or to find one specific record)