[AccessD] Harnessing SQL Server with runtime

Brad Marks BradM at blackforestltd.com
Thu Mar 17 11:03:05 CDT 2011


John,

Good point.  I had not thought of that.

None of our users have a full version of Access so this is currently not an issue, but things may change down the road.

Thanks,
Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of jwcolby
Sent: Thu 3/17/2011 10:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list