My end user has both access 97 and 2000 run-time players installed on the same machine. I'm trying to open a separate 2000 database from within the current 2000 .mdb the user has open, but it defaults to trying to open the db in 97. Is there a way to specify which version it opens it with. I tried the command line argument to the 2000 executable in the shellexecute command (see below) but without luck. Any thoughts????
iret = ShellExecute(Me.hwnd, _
vbNullString, _
DestinationFile, _
"C:\ProgramFiles\Microsoft\Office\ART\Office\MSACCESS.EXE",_
"c:\", _
SW_SHOWNORMAL)
iret = ShellExecute(Me.hwnd, _
vbNullString, _
DestinationFile, _
"C:\ProgramFiles\Microsoft\Office\ART\Office\MSACCESS.EXE",_
"c:\", _
SW_SHOWNORMAL)
