<div>
if it works perfect, just comment out the line that says:<br />
<br />
If MsgBox(&quot;Are you sure you want to reconnect all Access tables?&quot;, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; vbQuestion + vbYesNo, &quot;Please confirm...&quot;) = vbNo Then Err.Raise<br />
cERR_USERCANCEL<br />
<br />
<br />
or delete it entirely... then the user won't be asked.<br />
<br />
enjoy! ;-)<br />
<br />
dovholuk
</div>


if it works perfect, just comment out the line that says:

If MsgBox("Are you sure you want to reconnect all Access tables?", _
            vbQuestion + vbYesNo, "Please confirm...") = vbNo Then Err.Raise
cERR_USERCANCEL


or delete it entirely... then the user won't be asked.

enjoy! ;-)

dovholuk

<div>
<div class="content wysiwyg-content">
In my Front end Access 2000 database, I have several linked tables from SQL Server database. &nbsp;How can I make sure that all tables get connected when the front end is opened? That is I am looking for some code that will check that the tables are connected and then if not it will connect them for me (w/o prompting me to do it).<br />
<br />
ps. I found this which is perfect <a href="http://www.mvps.org/access/tables/tbl0009.htm" rel="ugc">http://www.mvps.org/access/tables/tbl0009.htm</a>&nbsp;except that it prompts the user to re-link the tables which I do not want to do.
</div>
</div>


In my Front end Access 2000 database, I have several linked tables from SQL Server database.  How can I make sure that all tables get connected when the front end is opened? That is I am looking for some code that will check that the tables are connected and then if not it will connect them for me (w/o prompting me to do it).

ps. I found this which is perfect http://www.mvps.org/access/tables/tbl0009.htm except that it prompts the user to re-link the tables which I do not want to do.

Relink Access tables from code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.