[AccessD] Reports, Forms, Queries, and Links in Library DB

Dan Waters dwaters at usinternet.com
Thu Dec 16 20:44:15 CST 2004


I've just been testing to see if I could put a form, report, query, or table
link into a referenced library mdb.  And, it works.  In a standard module in
the library database I put a procedure which accepts the name of the
appropriate object as an argument, then call that procedure from the main
mdb.


For example:

    Call OpenLibraryForm("frmTestForm")


In the library database is the procedure:

    Public Sub OpenLibraryForm(stgFormName As String)

        DoCmd.OpenForm stgFormName
    
    End Sub


The form/report/query will open fine, just as if it was in the main mdb.  I
did put a table link into the library mdb so that the objects had a data
source.

So - does anyone have experience with this practice?  Any pros/cons/gotchas?

Thanks,
Dan Waters
ProMation Systems




More information about the AccessD mailing list