Hi,

Any way to make my db connection to global so that i need not to declare it all the time whenever i m using db connection?
------------------------------------------
 Set objConn = New ADODB.Connection

 objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & CurrentProject.Path & "\Time tracker.mdb" & ";Persist Security Info=False"

  objConn.Open
------------------------------------------
Thanks in advance..

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

yeah of course, just declare it within a Module.

So in a module...
Dim DBConn as ADODB.Connection

You will need to initialise/set the connection somewhere in your startup code..
Set DBConn = New ADODB.Connection
DBConn.ConnectionString = "...."
DBConn.Open

Hope this helps,
Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

That's correct but i have to set connectionstring and rest all the time for all forms, anyway to create, initialise, set & open in module itself...??

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.