Opening connection

[yousufkhan]

Hi,
for a multiuser project in vb and sql how should open a conncetion
if i open a connection on the first main form is it ok or i ll need to open it on every module ?

[leinad31]

For ADO use a connection object declared public. You have to check its state (or set a boolean flag indicating its connected) before you use it in other forms modules.