Reference another Access DB

  • Thread starter Thread starter theArchitect
  • Start date Start date
T

theArchitect

Guest
I have a '97 database that I inherited, and although I have a reference set to it in another '97 database, I can only view (and use) the functions and methods of the modules- the classes are not visible in the Object Browser. What do I need to do to enable the Classes in the external database? (btw, I can see the Classes of the DB I am in, just not the external ones)

Thank you for the help, in advance!
 
Anyone have an answer?

I found a knowlege base article on how to enable the Classes to be available and useable from within another DB; The solution is to export the module as text, switch the Attribute VB_Exposed = True (default in '97 is False), and create a new Class with the same name (delete old one), and paste the code back in. But all of the Classes in the legacy DB would have to be saved this way- some 120. I could write an automation to do this (it's what programmers do), but I really am seeking a function that will instantiate all of the classes as needed.

I'm not sure if this forum is for complicated situations- most of the post I've read have been from novices (I'm not trying to be a wise guy- if I had the key to all knowlege, I would not be seeking answers). Does anyone use a function to encapsulate and instantiate classes in an external DB (or .mda)?

Thanks
 
Last edited:
Though there a really bright people here I would also try microsoft.public.access.formscoding and others in the msnews access groups. There are a ton of bright MVP's that hang out there daily.
 
No offense intended- I just think that a lot of the questions are on fairly basic topics- but everyone has to learn. Anyway, I have tried the microsoft.public.access newsgroups, but they have been down for as long as I have been trying to find an answer to this. I haven't been in there for a while, and when I get "Page not found", I start to think Micrsoft isn't supporting it any more. As I said, the KB article provided an answer- I just want a better one.

Thanks
 
Use a newsreader like Outlook Express. I get on those newsgroups several times a day. No offense taken and those MVP's earned their stripes.
 

Users who are viewing this thread

Back
Top Bottom