Reference Names in VBA Module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 6 different databases that I want to reference in modules in a seventh
db. I know I can go in and add a reference to those dbs but when I do they
all have the same reference name so that the only one that's actually
referenced is the last one I added. It's really strange because each of the
db's has a unique name and the title in the database properties is different
for each and when I right click in explorer and look at the title there it is
different for each. Can someone tell me where the Add Reference Dialog is
getting the name for the reference and how I can change that name?

Thanks so much!
 
MJatAflac said:
I have 6 different databases that I want to reference in modules in a seventh
db. I know I can go in and add a reference to those dbs but when I do they
all have the same reference name so that the only one that's actually
referenced is the last one I added. It's really strange because each of the
db's has a unique name and the title in the database properties is different
for each and when I right click in explorer and look at the title there it is
different for each. Can someone tell me where the Add Reference Dialog is
getting the name for the reference and how I can change that name?

Thanks so much!
Click to expand...

They all have the same VB Project name, probably because you copied
the MDBs. The VB Project name is not changed automatically when you
change the MDB file name.
Open the VB Editor, menu View/Project Explorer, select the Project,
menu View/Properties Window. There you can change the project name to
something unique that does not need to match the MDB file name.

HTH
Matthias Kläy
 
Back
Top