connection works just once after running VB+Access

[kzalex]

Hi,

Maybe somebody can give a clue

I have 4 computers: 1 server and 3 clients.

Every client can run VB program that connects to DataBase on server - Access (.MDB)

I wrote this programm. There is a very simple connection to DB, using basic function

of VB.

When I run it first time, everything works great.

(The same thing happens when I open VB code on client and try to ,ake file .EXE)

If I close the program and run it second time, I loose connection with the server completly,

including maping!!! So every time I want to run this program I have to do restart.


Thank you

[randem]

kzalex


First make sure you are closing your connections properly for Access will not unless you reboot.

Pssst: look at signature at bottom of post.