1

Topic: Object model of application Access

Kind time of days!
To me got in the inheritance very difficult and tangled application on  with very considerable quantity of objects. Which is forced to accompany. Application was written  by a trade and in it is not present lines on vba: all became on macroes.
Very difficultly and troublesome to understand all artful designs and correlations . After long, almost fruitless, attempts to understand I had a thought that it would be quite good to have the utility which would classify all objects and their correlations. Something like Object Dependencies, but much more advanced.  I tried to find something similar in a network but unsuccessfully. More truly such utilities and extensions mass,  they cover only a part of that I would like.
Probably the best method to understand what I want to enumerate it that does not suffice in Object Dependencies:
- Possibility at trace of objects in one direction since what or a place to continue to move in other. For example from a direction i depend on in a direction depend on me and on the contrary
- Absence of macroes and units
- Possibility of trace up to fields of tables, forms, requests and reports
- Switching-on in dependence also events of forms and reports and  with them of function, units and macroes.
Thus my question consists in, whether there is a utility or the extension which could satisfy somewhat above-stated with me wishes?
Thankful in advance for any information on this question.

2

Re: Object model of application Access

Horror, I sympathize. Access Dependency Checker tried? Macroes supports, remaining too like is.
If it is made on macroes, the superdifficult logic there is not present, I would consider conversion of all this nightmare in VBA. Automatic machine Aks makes a lion's part of operation, well and further hands it is necessary to correct. If it is necessary to support seriously this operation pays off.

3

Re: Object model of application Access

MrShin wrote:

Horror, I sympathize. Access Dependency Checker tried? Macroes supports, remaining too like is.
If it is made on macroes, the superdifficult logic there is not present, I would consider conversion of all this nightmare in VBA. Automatic machine Aks makes a lion's part of operation, well and further hands it is necessary to correct. If it is necessary to support seriously this operation pays off.

Here only macroes happen 2 types
--Normal, easily translated in the code
--Implemented - much more opposite

4

Re: Object model of application Access

MrShin wrote:

If it is made on macroes, the superdifficult logic there is not present,

+
Also cannot be on determination...
For this purpose that is not translated from language of deaf-mutes - the most simple way to analyze an input and an output and to write at once the...

5

Re: Object model of application Access

MrShin;
At me everywhere costs msaccess2003. Access Dependency Checker it is probable in newer versions access.
About conversion of macroes in vba. Actually not macroes frighten me, and a considerable quantity of objects and the tangled correlations in between. So for example tables more than 100, requests more than 700, forms more than 300, reports more than 600, objects  more than 700 in each of which on  macroes. So I doubt <that conversion facilitates to me life: Instead of 700  will be 700 units of all that.

6

Re: Object model of application Access

wrote:

here only macroes happen 2 types
--Normal, easily translated in the code
--Implemented - much more opposite

What means implemented macroes?

7

Re: Object model of application Access

Idealist57 wrote:

MrShin;
At me everywhere costs msaccess2003. Access Dependency Checker it is probable in newer versions access.
About conversion of macroes in vba. Actually not macroes frighten me, and a considerable quantity of objects and the tangled correlations in between. So for example tables more than 100, requests more than 700, forms more than 300, reports more than 600, objects  more than 700 in each of which on  macroes. So I doubt <that conversion facilitates to me life: Instead of 700  will be 700 units of all that.

Be mistaken. The unit can be one. But with 700 procedures.

8

Re: Object model of application Access

Idealist57 wrote:

it is passed...
What means implemented macroes?

These are macroes in forms and reports and   2007

9

Re: Object model of application Access

Idealist57 wrote:

At me everywhere costs msaccess2003. Access Dependency Checker it is probable in newer versions access.

works since 2000. I use version 1.0.1, with the second there were problems with start. So try, I recommend. In my opinion simply irreplaceable thing for the analysis of applications.

10

Re: Object model of application Access

MrShin wrote:

it is passed...
works since 2000. I use version 1.0.1, with the second there were problems with start. So try, I recommend. In my opinion simply irreplaceable thing for the analysis of applications.

It  in standard delivery 2003 or this extension?

11

Re: Object model of application Access

Idealist57;
http://www.accessdependencychecker.com/ … e=download

12

Re: Object model of application Access

Similar good . I will understand.
Thanks for the link.

13

Re: Object model of application Access

Yes by the way. Version 2.0.1 at me did not earn. The error jumps out

wrote:

The expression On Click you entered as the event property setting produced the following error: A problem occurred while a Microsoft Access was communicating with the OLE Server or ActiveX Control.

In the beginning thought problems with my basis, but then tried on absolutely empty basis and the same result. It was necessary to install version 1.0.2. From here 2 questions:
- Why version 2.0.1 does not work for me? At me Windows Server 2012 R2 Standart and Access2003
- Whether the big difference between versions?

14

Re: Object model of application Access

I understand with Access Dependency Checker.
At attempt to open window ObjectDetails is jumped out few times by an error then the window opens but in the right part of a window is empty.
Wanted to lay out here a screen but it did not turn out. Prompt as it to do.