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.