[AccessD] Harnessing SQL Server with runtime

Brad Marks BradM at blackforestltd.com
Thu Mar 17 09:20:17 CDT 2011


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