How can I get table names from an MS Access Database?

To build on Ilya’s answer try the following query: SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) In (1,4,6))) order by MSysObjects.Name (this one works without modification with an MDB) ACCDB users may need to do something like this SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) …

Read more

Get Name of Current VBA Function

There’s nothing to get the current function name, but you can build a fairly lightweight tracing system using the fact that VBA object lifetimes are deterministic. For example, you can have a class called ‘Tracer’ with this code: Private proc_ As String Public Sub init(proc As String) proc_ = proc End Sub Private Sub Class_Terminate() …

Read more

How does one decompile and recompile a database application?

To Decompile an Access database you’ll need to create a shortcut with the following elements: Path to the MS Access Executable (MSACESS.exe) Path to the database you would like to decompile The /decompile flag All together, then, the shortcut would look something like the following: “C:\Program Files\Microsoft Office\Office\MSACCESS.EXE” “C:\users\tim\documents\Mydatabase.mdb” /decompile Obviously, the paths will be …

Read more