Running a .accdr file from the shell command

[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

 

[Dirk Goldgar]

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.

Have you tried this:

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

?

 

[Dave Reardon]

Have you tried this:

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

?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

Thanks Dirk

Simple, but effective.

Regards

Dave