MSysObjects & add-in

[Aaron Kogan]

i created a form that lists objects in the MSysObjects table. i then created
an add-in w/ this form.
the problem is when i 'run' the add-in, the list of objects is from the
..mda/add-in file and NOT from the .mdb file i am accessing the add-in from.

how do reference the .mdb file's MSysObjects table and NOT the .mda's table?

thanks,

aaron

 

['69 Camaro]

Hi, Aaron.

the problem is when i 'run' the add-in, the list of objects is from the
.mda/add-in file and NOT from the .mdb file i am accessing the add-in
from.

Create a recordset from the MSysObjects table in the CurrentDb(), not the
CodeDb(). Use this recordset to list the objects.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.