[AccessD] Harnessing SQL Server with runtime

Release it as an ADE/MDE ;)



On Thu, Mar 17, 2011 at 8:31 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> > 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
>>>
>> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>