|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
exporting VBA code and table information on remote DB
I am making changes to my file server which requires that I look through roughly 150 Access 97 DB's to find linked tables and code that refers to a particular server or UNC path. Does anyone know of a utility that will help me identify database table properties (linked tables in particular) or export VBA code to a .BAS file that I can search against versus having to open each Access DB and manually search through modules and linked table manager.
|
|
#2
|
|||
|
|||
|
I banged out a module in VB that will open an access database, step through each table and output the linked table path. Maybe it'll help. It uses the DAO library.
Public Sub main() Dim MyDB As DAO.Database Set MyDB = OpenDatabase("d:\db1.mdb") Dim tbl As DAO.TableDef For Each tbl In MyDB.TableDefs Debug.Print tbl.Properties(4) Next tbl End Sub Matt. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > exporting VBA code and table information on remote DB |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|