This video will feature instructions for re linking the BAT backend database files.
The MS access files provided in the BAT are linked.
When these files become unlinked,
you will get an error message when you open the BAT.
Fortunately, re linking the files
or linking back end files is straightforward.
I will demonstrate the steps to re link
database tables using MS Access 2016.
If you are using MS Access 2013,
please refer to Appendix B of the BAT User Guide
as a procedure will be slightly different.
On the access menu,
Click on the external data heading and then select the linked table Manager
Access will open the linked table
Manager Wizard
on the Linked Table Manager Wizard Click Select all
and then select Delete to clear the previous data sources
when access prompts you
to make sure you want to delete the link to the table,
Select Yes.
Let's re link or add
the two new back end data files.
Both of these files are needed for all features of the BAT to function properly.
First, click on the add button and select the Access radio button.
Then click Next,
Browse to the back end file of the DHS BAT directory.
After selecting the data file,
click finish
and a new table manager will launch.
Choose the select all button as I'm doing now and then select,
Okay,
now we will link the Dell Building
archive table following the same process as before.
Click the add button and then select the Access radio button.
Then click next.
Now browse to the Dell Building Archive folder and select
ArchiveBldg_Data.accdb
click finish.
And now we are greeted with the window from before, but this time do not press
select all if you do, the BAT will not function properly.
Select only data audit building archive from the list
and then press. Okay
The system will process and return to the initial screen.
Make sure there is a checkbox in each data source name field.
If not, check the box.
Press the close button.
You can collapse the navigation pane on the left
by clicking on the double arrow at the left, heading
then exit from the file or close access before you relaunch the BAT.
When you log back in,
the tables will be linked and the BAT will be opened normally.