How make time tracker.mdb dynamic. Just like we do in ASP / VB (e.g. server.mappath('dbName')?

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

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

How else do you make a string dynamic?

Replace the value with a variable and set the variable at run time.

<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>

Okay,,even if i set it through variable, how that will catch .mdb file in current folder? (By default it searches in "My Document" folder..

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

Use the CurrentProject.Path property to return the path of the currently open Access Project (presumably your
Front-End as it seems you are using FE/BE architecture.

<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>

Thanks Rob, it is solve now..

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

Rupen,

Glad to hear it, HTH.

Rob

<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>