Hi gang.
Writing a large VB app - networkable etc.
When I access a file from a PC on the network, everything works fine. I can access the file via my program, Word, Explorer etc etc.
If the machine I accessed the file from is then closed down, weird things happen!
1. I can't run my VB app from the IDE - I get a 3028 error (workgroup security file does not exist - but it does, and the registry entry is correct). I can open the database in Access however.
2. I can't access VB Help - VB tells me the help file is unavailable. But I can run the EXE via Windows Explorer.
3. Outlook Express keeps brute-forcing my hard disk!!!
If you are running an EXE, the program is VERY slow the first time the database is accessed after the network PC is turned off...after this it seems fine.
(I should mention here that the database is on the local PC).
This happens on Win 95/98/NT4/ME/2000 SP1.
Ways to solve the problem:
1. Turn on the PC that was turned off.
2. Close down VB, then restart it.
3. Restart your computer.
4. Make a connection to another computer on the network.
It seems Windows is holding the last connection made, and is timing out trying to find what is now a dead connection.
The 3028 error is not the real error being reported...it's just the first one VB happens upon, so it reports it.
Any ideas will be gratefully received!!
If you want to reproduce the error, write a simple little VB prog:
1. Stick a data control on a form and connect it to any Access DB.
2. Bind a text box to a field in the data control's recordset.
3. Via Windows Explorer, connect to a networked PC. Open a file on this PC.
4. Close the file on the network PC, then shut the network PC down.
5. Try running the program from VB (you should have left VB open at all times throughout this process).
If anyone gets different results to me, please let me know!
Cheers,
Mokil.
Writing a large VB app - networkable etc.
When I access a file from a PC on the network, everything works fine. I can access the file via my program, Word, Explorer etc etc.
If the machine I accessed the file from is then closed down, weird things happen!
1. I can't run my VB app from the IDE - I get a 3028 error (workgroup security file does not exist - but it does, and the registry entry is correct). I can open the database in Access however.
2. I can't access VB Help - VB tells me the help file is unavailable. But I can run the EXE via Windows Explorer.
3. Outlook Express keeps brute-forcing my hard disk!!!
If you are running an EXE, the program is VERY slow the first time the database is accessed after the network PC is turned off...after this it seems fine.
(I should mention here that the database is on the local PC).
This happens on Win 95/98/NT4/ME/2000 SP1.
Ways to solve the problem:
1. Turn on the PC that was turned off.
2. Close down VB, then restart it.
3. Restart your computer.
4. Make a connection to another computer on the network.
It seems Windows is holding the last connection made, and is timing out trying to find what is now a dead connection.
The 3028 error is not the real error being reported...it's just the first one VB happens upon, so it reports it.
Any ideas will be gratefully received!!
If you want to reproduce the error, write a simple little VB prog:
1. Stick a data control on a form and connect it to any Access DB.
2. Bind a text box to a field in the data control's recordset.
3. Via Windows Explorer, connect to a networked PC. Open a file on this PC.
4. Close the file on the network PC, then shut the network PC down.
5. Try running the program from VB (you should have left VB open at all times throughout this process).
If anyone gets different results to me, please let me know!
Cheers,
Mokil.