<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have to make an architecture desicion, any tips are welcome.<br />
<br />
a) Accessing an MS Access-database on a NT-server directly through a DSN on the clients. (with ADO or DAO)<br />
<br />
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. <br />
<br />
What are the consequences for performance, and do I have to use multithreading for option B?<br />
<br />
(btw: most of the time, the database is only used to retrieve either a complete table or to find one specific record)
</div>
</div>


Hi Experts,
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)

Client/server architecture design

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.