Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 16th, 2003, 02:45 PM
TricycleAvenger TricycleAvenger is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 1 TricycleAvenger User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
  #2  
Old December 18th, 2003, 01:07 PM
madmatt75 madmatt75 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Location: Binghamton, NY
Posts: 22 madmatt75 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > exporting VBA code and table information on remote DB


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway