<div>
You could write a routine to check for the existance of your<br />
database file. &nbsp;If it has been moved, then you could have a <br />
routine look for it, then change the databasename property<br />
to the new path. &nbsp;I built an activeX control to do this.<br />
<br />

</div>


You could write a routine to check for the existance of your
database file.  If it has been moved, then you could have a
routine look for it, then change the databasename property
to the new path.  I built an activeX control to do this.



<div>
Hi Mike, Thanks for answering my question but can you show me how to do it. thanks <br />
Lori<br />

</div>


Hi Mike, Thanks for answering my question but can you show me how to do it. thanks
Lori


<div>
In addition to the proposed solution, you could store the Database Name in an INI/Registry setting.<br />
<br />
In the Form_Initialize Event you would read the Setting and verify the existence of the DB.<br />
<br />
If the file/path are good, set the datacontrol.databasename = INI setting<br />

</div>


In addition to the proposed solution, you could store the Database Name in an INI/Registry setting.

In the Form_Initialize Event you would read the Setting and verify the existence of the DB.

If the file/path are good, set the datacontrol.databasename = INI setting


<div>
To check if a file exist:<br />
<br />
If Dir(&quot;C:\Windows\Db1.mdb&quot;)=<wbr />&quot;&quot; then 'Not exist<br />
&nbsp;CreateDatabase &quot;C:\Windows\Db1.mdb&quot;, dbLangGeneral<br />
&nbsp;Data1.DatabaseName=&quot;C:\Win<wbr />dows=Db1.m<wbr />db&quot;<br />
&nbsp;Data1.Refresh<br />
End If<br />
<br />

</div>


To check if a file exist:

If Dir("C:\Windows\Db1.mdb")="" then 'Not exist
 CreateDatabase "C:\Windows\Db1.mdb", dbLangGeneral
 Data1.DatabaseName="C:\Windows=Db1.mdb"
 Data1.Refresh
End If



<div>
Guys, you are wonderful.. I will give your web address to all my friends!<br />

</div>


Guys, you are wonderful.. I will give your web address to all my friends!


<div>
<div class="content wysiwyg-content">
Hi,<br />
All my forms have link with the database by data control. the path look like this &quot;C:\WINDOWS\DESKTOP\scan\S<wbr />OC.mdb&quot; &nbsp;how about if someone moves the databse from this location, the program will not run! is ther any solution! thanks
</div>
</div>


Hi,
All my forms have link with the database by data control. the path look like this "C:\WINDOWS\DESKTOP\scan\SOC.mdb"  how about if someone moves the databse from this location, the program will not run! is ther any solution! thanks

Data Control

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.