Access 97 Shell

[jeremy Grubba via AccessMonster.com]

I am Shelling out to an Access 97 from an Access 97 DB. The reason is that we
want to have dynamic reporting and we can not have an MDE be dynamic. As any
changes to the form needs to be done in design mode. The other part of the
program (where we are shelling from) can be an MDE. Which is what we want.
Now. The problem is that this all works fine on the development computer yet
the Shell locks up on every other PC we try this on. I have (please don't
laugh too hard) about 80 checkboxes that I make visible and move into
position based on whatever reporting options the user wants. We choose 80 as
a max number. There are a total of 86 controls on this form so I don't think
there has been a limit reached. Is there anyone that has any ideas. I hope I
conveyed my problem so it can be understood.

 

[Douglas J. Steele]

Have you considered using Automation, rather than shelling?

 

[jeremy Grubba via AccessMonster.com]

No I haven't. I will look into it. Thanks for a fresh idea.

 

[jeremy Grubba via AccessMonster.com]

I did not get a chance to try the Automation. I was instructed to just make
it work and to forget about the MDE. The two seperate databases have become
one and now everything works.

 

[Guest]

If you wish, you can move some of the contents of the mdb into
a seperate mde and use the mde as a library reference. The dynamic
reports can be in the base mdb, and some or all of the library code
and forms in the reference mde.

(david)