?
Solved

uncover hidden objects

Posted on 2015-02-12
2
Medium Priority
?
168 Views
Last Modified: 2016-02-11
I have inherited several old MS Access databases (.mdb) and am in the process of converting them to .accdb.  In addition, I am organizing the databases and extract 'common data' and moving them to a single database that will be linked to the other databases.  This will allow us to keep data current and limit who has access to updating the data.

In the process of creating the new .accdb database -- and copying all of the object in from the .mdb version - I noticed that there was a module and form that were brought over that were not visible in the old .mdb database.  I tried re-compiling the module in the new .accdb - and I get an error msg (see attached) indicating 'User-defined type not defined'.  When I go back to the old .mdb database, I don't even see this module listed and the form is open in design mode.  There is no documentation for the old .mdb database - so I am trying to determine what this 'hidden' module is doing.

Any ideas how to find this module in the old .mdb database?  Any ideas on how to determine what it is doing?

Could there be an external executable that calls this module?

Thanks for the help,
je
C---MS-Access-Database-Consolidation-Err
0
Comment
Question by:Jeanne Elmuccio
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40606086
I can't open your attachment because I don't know what it is.

 As for the error, you'll need not only the code, but the References as well.

 In the old DB, open VBA and look at tools/references.  Those will need to be either:

1. Duplicated in the new DB
2. Replaced with a later version.
3. The code in question that uses the reference be replaced with something else.
4. The code in question that uses the reference be discarded if no longer needed.

Jim.
0
 

Author Comment

by:Jeanne Elmuccio
ID: 40606280
It seems to work fine even when the code is not compiled.  I tried creating a fake module in the old .mdb database to look at the references -- and got the same compile error.  So I think I'll just leave it as is for now.

Thanks for pointing me to the references.
je
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question