Hi all, it's been a year since I've been on here.
Got a problem, help please.
I have an Access db (Stock manager). This is accessed by 2 pcs across the LAN with no problems whatsover using a Stock Manager program written in VB6 using DAO3.6. It is also accessed by the same pcs running a different program that also manipulates the data. This program is also VB6/DAO 3.6.
Now I am very careful to close every recordset and set each to nothing. Nothing is left open. I open, read or write, then close immediately and set to nothing. At the end of the session I also set the db object and workspace object to nothing (after closing both).
However, after I've used this second prog (not the stock manager prog) on my PC (W2k server), the second pc on the LAN (WXP) often (not always) cant open it due to error 3051 - basically saying my one still has it open. But it's not - of that I'm certain (I think). There is no ldb file.
Meanwhile both pcs can still open the db via the stock manager program. By the way the db is actually stored on the second pc (the one that can't open it via the 'other' prog). The only way to clear the problem is to shut down the first (W2k) pc.
The problem never seems to manifest itself the other way round (i.e. PC2 opens prog and prevents PC1).
Help please.


____________________________
While Breath.Count>0
       Live(gbRelax)
Wend