[AccessD] Runtime when full version is installed

I agree with that assessment. However, if the client really wants the full
install and you want them to run your database using the runtime.  The
quickest and easiest is to change the extension of the file to accdr. Access
will treat it as if it's running under runtime.  Yes, the extension can be
changed back quite easily.  However, with a little bit code it won't run
without the proper extension.
Such as: 
If SysCmd(acSysCmdRuntime) = False Then
   'Should be using runtime but if not, quit application.
   If MsgBox("This file is in the wrong format and will not run.",
vbCritical, "Application Quit") = vbOK Then
       Application.Quit
   End If
End If

I put this in the on open event of the first form that opens.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, September 13, 2011 9:16 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Runtime when full version is installed

Hi John

Non-profit and full Office 2010 doesn't match costly wise. Are you they need
Access on all machines? We've never had a client - profit or none - with
that demand; we always use the Office 2010 for home and small business with
the cheap PCK license.

/gustav


>>> jwcolby at colbyconsulting.com 13-09-2011 16:01 >>>
I have a small (non-profit) client that wants me to install full office 2010
on all of their 
employees systems.  However I want my Access App to run under the runtime.
Mostly just for that 
additional security of not allowing them access to design time stuff unless
they intentionally open 
the app under the full version.

I have installed the runtime on other machines but I do not remember if the
runtime install allows 
me to set the destination (install) directory.

Is anyone using the runtime?  Any tips or tricks for this scenario?

-- 
John W. Colby
www.ColbyConsulting.com 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com