Having a problem with ADO used with access97 across the network with File DSN. It hangs most of the time , unless the connection is closed and opened again. Is there any work around to that. Also the connection which i am using is opened once during the project.
What are the other things I should consider for using ADO2.7 with access97 across the network.