Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Linkerxf_LinkerTable Linker
Public Function TestDbTableLinks (
dbs As DAO.Database,
DB_ID As Long,
DB_Description As String,
DB_FilePath As String,
DB_Password As String,
Optional AddLocalTablePrefix As Boolean = False,
Optional SelectiveLinkSql As String = ""
) As Boolean
Checks:
- that each linked table listed in the linker configuration has a matching linked table in the database
- that a single table from each linked database successfully returns data
dbs as DAO.Database
The database containing the table linker tables (usually the current database)
DB_ID as Long
The database ID in the linker table
DB_Description as String
The description of the database to be linked
DB_FilePath as String
The file path of the database to be linked
DB_Password as String
The password of the database to be linked
Optional AddLocalTablePrefix as Boolean = False
Add the prefix for 'local fallback' mode tables
Optional SelectiveLinkSql as String = ""
A WHERE statement to restrict the tables being linked
Call Template:
Dim b As Boolean
b = xf.Linker.TestDbTableLinks(dbs, DB_ID, DB_Description, DB_FilePath, DB_Password)
b = xf.Linker.TestDbTableLinks(dbs, DB_ID, DB_Description, DB_FilePath, DB_Password, AddLocalTablePrefix, SelectiveLinkSql)