MS Access modules

[zdrakec]

Hullo all:

Is there a nifty way to retrieve a list of the macros / code modules in
an MS Access database using ADO.NET, a la
OleDB.OleDBConnection.GetOleDbSchemaTable for retrieving tables and
views?

Thanks much,

zdrakec

 

[Norman Yuan]

No, you cannot use ADO.NET to find macros/modules in Access. Access file
(*.mdb/*mde) is container for both MS Accss application and Jet database.
With ADO.NET you might be able to get info on Jet databse part, but
definitely not on MS Application part (Even on Jet database part, you may
have to use DAO or ADOX in COM interop to retrieve table structure as you
want).

Since macros/modules are part of Access application, you can use COM
automation to connect to MS Access (but for what purpose, I wonder).

 

[zdrakec]

Hello Norman:

Well, that is what I needed to know. I was hoping to avoid using any
com automation for this. I have an app that needs to display to the
user the macros available in any give .mdb, on demand.

Thanks anyway,

zdrakec