|
|
Подключение всех таблиц внешней БД (DAO) v014
Public Function LinkAllTables_MSADB_DAO(sSrcDBPath As String, Optional sLocalPrefix$ = "") As Long
Dim dbSrc As DAO.Database, tdfSrc As DAO.TableDef
Dim dbLocal As DAO.Database, tdfLocal As DAO.TableDef
Dim sSrcDBConnectionStr$, sSrcTableName$, sLocalTableName$
Dim iConut%
On Error GoTo LinkAllTables_MSADB_DAO_Err
Set dbLocal = CurrentDb
Set dbSrc = DBEngine.OpenDatabase(sSrcDBPath)
sSrcDBConnectionStr = ";DATABASE=" & sSrcDBPath
For Each tdfSrc In dbSrc.TableDefs
If tdfSrc.Attributes = 0 Then
sSrcTableName = tdfSrc.Name
sLocalTableName = sLocalPrefix & sSrcTableName
If DCount("*", "MSysObjects", "[Name] =
|
|