Question No tables in referenced library

[mcdhappy80]

I've created library reference as an accde access database. In it I have 9 tables and 1 module. When I add reference to it from VBA Editor I don't see the tables in the database just the code module. I've read in access 2007 bible that I can use tables as well as forms, code, and reports.
What am I doing wrong? How do I display tables too?
Thank You

 

[boblarson]

Perhaps this page will shed a little light on it.

 

[mcdhappy80]

Thnx Bob. Can You please tell me how to dynamically reference library from FE database?

Where do I need to put the IN statement because I'm accessing data in tables that are in library. Also this function where the SQL is is in library module, and I'm calling it from FE.

strSQL = "SELECT tblAplikacija.txtAplikacija, tblKorisnik.txtKorisnik, tblTabela.txtTabela, tblDb.txtDb, tblPutanja.txtPutanja " _
    & "FROM ((tblKorisnik INNER JOIN ((tblAplikacija INNER JOIN tblAplikacijaKorisnik " _
    & "ON tblAplikacija.intAplikacijaID = tblAplikacijaKorisnik.intAplikacijaID) INNER JOIN tblAplikacijaTabela " _
    & "ON tblAplikacija.intAplikacijaID = tblAplikacijaTabela.intAplikacijaID) " _
    & "ON tblKorisnik.intKorisnikID = tblAplikacijaKorisnik.intKorisnikID) INNER JOIN tblPutanja " _
    & "ON tblKorisnik.intKorisnikID = tblPutanja.intKorisnikID) INNER JOIN ((tblDb INNER JOIN tblDbPutanja " _
    & "ON tblDb.intDbID = tblDbPutanja.intDbID) INNER JOIN tblTabela ON tblDb.intDbID = tblTabela.intDbID) " _
    & "ON (tblTabela.intTabelaID = tblAplikacijaTabela.intTabelaID) AND (tblPutanja.intPutanjaID = tblDbPutanja.intPutanjaID) " _
    & "WHERE (((tblAplikacija.txtAplikacija)='" & txtImeAplikacije & "') AND ((tblKorisnik.txtKorisnik)='" & strImeKompjutera & "'));"

Thank You.