Running a .accdr file from the shell command

  • Thread starter Thread starter Dave Reardon
  • Start date Start date
D

Dave Reardon

I have overcome a problem of getting a database to update by launching a
second database which then copies the file over to the specified location.
However, when I attempt to get it to open the new version, I get an error
message saying the file was converted to runtime mode (which is correct) to
open the file either double click it in Windows Explorer, open it by using a
shortcut or use the /runtime command line switch.

I am currently using:
strOpenClient = "MSAccess.exe " & q & strDest & q
Shell strOpenClient, vbNormalFocus
where 'strDest' is defined as the destination of the .accdr file. All other
steps appear to work correctly.

Thanks in anticipation.

Dave
 
Dave Reardon said:
I have overcome a problem of getting a database to update by launching a
second database which then copies the file over to the specified location.
However, when I attempt to get it to open the new version, I get an error
message saying the file was converted to runtime mode (which is correct)
to
open the file either double click it in Windows Explorer, open it by using
a
shortcut or use the /runtime command line switch.

I am currently using:
strOpenClient = "MSAccess.exe " & q & strDest & q
Shell strOpenClient, vbNormalFocus
where 'strDest' is defined as the destination of the .accdr file. All
other
steps appear to work correctly.
Click to expand...


Have you tried this:

strOpenClient = "MSAccess.exe " & q & strDest & q & " /runtime"
Shell strOpenClient, vbNormalFocus

?
 
Back
Top