Open Application in Access Runtime

[TheTomCat]

I know how to simulate a runtime environment by adding
/runtime to the end of the shortcut line.
I distribute my application using Office XP (2002) Packaging Wizard. I want my application to open in runtime even if the user has the full version of Access.
Isn't there a way, in the Packaging process, that I can tell it to do that?
Thanks for any help.

Thomas Bailey
a/k/a TomCat

 

[jrbarnett]

Not sure of the exact location of the runtime executables in a standard install, haven't got access to it now, but its something like:

"C:\Program Files\Microsoft Office\Access Runtime\Accessrt.exe" "C:\Program Files\Your App\Yourdb.mdb"

You just need to set the path to the database in the start menu or desktop shortcut to use this.
It won't change the default handler for DB files, so they can still double click the file from windows explorer to open in full access, but there's not much you can do about that short of giving it a custom extension and associating that with access runtime (which means extra support overheads).

John

 

[Hap007]

Hi,

I believe if the person has the full version of Access, using the /runtime switch will work, but they can always open in full access mode if they want to.

You might want to try hiding the menu choices at startup time.

Create a form, place 2 buttons on the form and see if this hiding of the menu items helps you.

Private Sub HideToolBarBtn_Click()
On Error Resume Next
With DoCmd
.Echo False
.ShowToolbar "Menu Bar", acToolbarNo
.ShowToolbar "Formatting (Form/Report)", acToolbarNo
.ShowToolbar "Form View", acToolbarNo
.Echo True
End With
End Sub

Private Sub ShowToolBarsBtn_Click()
On Error Resume Next
With DoCmd
.Echo False
.ShowToolbar "Menu Bar", acToolbarYes
.ShowToolbar "Formatting (Form/Report)", acToolbarYes
.ShowToolbar "Form View", acToolbarYes
.Echo True
End With
End Sub


Good Luck,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121