|
|
| jeremy Grubba via AccessMonster.com 2005-06-16, 8:26 pm |
| 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.
--
Message posted via http://www.webservertalk.com
| |
| Douglas J. Steele 2005-06-16, 8:26 pm |
| Have you considered using Automation, rather than shelling?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"jeremy Grubba via webservertalk.com" <forum@nospam.webservertalk.com> wrote
in message news:4FF2D18B45FB0@w
ebservertalk.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.
>
> --
> Message posted via http://www.webservertalk.com
| |
| jeremy Grubba via AccessMonster.com 2005-06-17, 9:24 am |
| No I haven't. I will look into it. Thanks for a fresh idea.
--
Message posted via http://www.webservertalk.com
| |
| jeremy Grubba via AccessMonster.com 2005-06-17, 1:26 pm |
| 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.
--
Message posted via http://www.webservertalk.com
| |
|
| 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)
"jeremy Grubba via webservertalk.com" <forum@webservertalk.com> wrote in
message news:4FFE5C6CCA3E0@w
ebservertalk.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.
>
> --
> Message posted via http://www.webservertalk.com
|
|
|
|