I have two pc's set up 24 hrs a day which are just for order entry. Both pc's are connected to the same Access mdb on a 3rd pc and process 300 records max between them in a day. I am making the connection to the database upon program startup without disconnection. The users have reported occasional errors with the two systems losing their connection to the database - thereby needing a reboot to regain connection. My question is: Am I using a good practice to connect to the db at program startup or should I connect and then disconnect when a user finishes entering a new record?

If it matters, I am using ADO 2.1

Running VB6 SP3, NT4 SP51

Thanks all!