[AccessD] Harnessing SQL Server with runtime

 > 2) It automatically locks things down so that users cannot get at the VBA code, change things, etc.


Just be careful with this thinking.  If you distribute the MDB it can be moved to any machine which 
does have the full Access install and can be modified there.

John W. Colby
www.ColbyConsulting.com

On 3/17/2011 10:20 AM, Brad Marks wrote:
> John,
>
> We have had pretty good luck with Access 2007 Runtime.
>
> There are two main reasons why we deploy it for our users.
>
> 1) It is free (We have only purchased one "full version" and we have many copies of the Runtime)
>
> 2) It automatically locks things down so that users cannot get at the VBA code, change things, etc.
>
> If you run into issues, please post them and I will try to help if I can.
>
> You have posted an incredible amount of valuable info here on AccessD which has been beneficial to the rest of us.  Now maybe we can offer a helping hand to you with Runtime.
>
> Brad
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com on behalf of jwcolby
> Sent: Thu 3/17/2011 7:50 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Harnessing SQL Server with runtime
>
> That is good to know Brad.  You are the first person in the group to really fess up to using the run
> time.  It has been a learning experience trying to get all of the details ironed out.  Trying to
> troubleshoot if I have problems is a royal PITA since I have no clue how to get feedback from the
> application.
>
>   From what I was reading the runtime did not allow changes to objects even programmatically.  If it
> will allow that then I will be able to do much more with my apps.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 3/16/2011 5:27 PM, Brad Marks wrote:
>> John,
>>
>> I might be misunderstanding things (like a good Minnesotian I will
>> apologize up front) but I thought that I would reply with info that
>> might be useful.
>>
>> We use Access 2007 Runtime quite a bit.
>>
>> While it is true that a person cannot modify objects via the "user
>> interface", we have applications that change Query-Defs (using VBA code)
>> in the Runtime environment.
>>
>> Brad