Problem Opening Multiple Access Databases

  • Thread starter Thread starter JeffTO
  • Start date Start date
J

JeffTO

Hi All

I have a stange thing happening - I am using Access 2000

I was able to open multiple databases with no problem - each would
open as it was supposed to (normal, maximized, database window
displayed etc.)

Now I can open the first Database proplery but any subsequent database
that I try to open seems to open totally minimized - Access WIndow is
minimized (which I have to maximize) - Data Window is minimized within
the Access Windo (which I have to maximize)

This is a very big pain that I do not know what caused it and/or how
to fix it.

I think part (if not all of the problem) came from some automation
code I was workingw with - I built something that opened up an
instance of Access and I was testing opening it up using
"vbMinimizedFocus" - with the code:

CmdToOpen = """" & SysCmd(acSysCmdAccessDir) & "Msaccess.exe""" & "
""" & CopyDBFull & """"
Shell CmdToOpen, vbNormalFocus
(where CopyDBFull was the path of the file to be opened)

Ever since I did tihs I seem to be having the problem - I have since
re-ran that code using both vbNormalFocus and vbMinimizedFocus to see
if would correct my problem

Any thoughts on helping to fix this would be greatly appreciated

Thanks,

Jeff
 
m:
Now I can open the first Database proplery but any subsequent
database that I try to open seems to open totally minimized -
Access WIndow is minimized (which I have to maximize) - Data
Window is minimized within the Access Windo (which I have to
maximize)
Click to expand...

It's not clear to me from your full message whether or not you mean
opening your additional instances via automation code or via the
Windows user interface.

If it's the latter, one thing you might want to check is whether
it's really minimized, or whether it's just a really small window.
If it's the latter, resizing it to a reasonable size might make a
difference (even though it's not precisely what I assume you want,
i.e., maximized).
 
you can always launch MSACCESS.exe and then file, open the 2nd
database (even when the 1st database is busy thinking)
 
Back
Top