Controlling Access Window Size

[MikeLaBrecque]

I have an Access database where the Access window is sized to be very small.
Problem is when you open any other access database on the same PC. The other
databases open at the same small size. Is there a way to have Access retain
the sizing parameters for a specific database. I think this falls into a
profile scenario, but I'm not sure. I have tried restoring the size right
before exiting the app, but that appears klunky. Any ideas out there....

 

[Chris Mills]

You can run your "very small" app in a separate instance of Access, if it
needs to be that way.

Chris

 

[MikeLaBrecque]

Thanks Chris, but can you elaborate. Does a seperate instance of Access
mean seperate registry settings. How does one tell the database to run
seperately. Thanks, Mike

 

[Chris Mills]

Just start Access twice, via any command line or shortcut you use to start
Access.

(In fact, there's a danger of a user with fumbly fingers or errant mouse
running more than one instance of your app!)

Some people might consider it memory-hungry to run 2 instances of Access, but
no more so than any large program, and you wanted them totally independent.

I'm not aware of any registry settings you'd muck with. In your small app you
might control it down to the size you want (with startup code), and for normal
apps you might maximize them (with startup code). In any case, or otherwise,
the user can control each instance independently. At least, I've just verified
that with A2002.

It's not normal to want a very small screen. I always maximise. Is this some
small "automatic program" you want to run permanently? In which case, a
separate instance is the way to go.

(Aha! You may need to run a command line rather than double-clicking an mdb
e.g. \...\msaccess.exe myapp.mdb)

Chris

 

[MikeLaBrecque]

Thanks again for your help. This is not really the solution I am after. I
am hoping to find a more elegant way to handle this problem. But, I
appreciate your effort.