[AccessD] [Spam]8.31 Re: Access2010 Runtime problem

Darrell Burns dhb at flsi.com
Wed Aug 31 17:00:47 CDT 2011


Oh, gotcha. All permissions are checked.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, August 31, 2011 2:41 PM
To: Access Developers discussion and problem solving
Subject: [Spam]8.31 Re: [AccessD] Access2010 Runtime problem

Right click on the file,  Select Properties - Security

--
Stuart

On 31 Aug 2011 at 14:23, Darrell Burns wrote:

> Where do you set permissions?
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> McLachlan Sent: Wednesday, August 31, 2011 1:57 PM To: Access 
> Developers discussion and problem solving Subject: Re: [AccessD]
> Access2010 Runtime problem
> 
> User permissions on the application itself?
> 
> I've come across a situation in the past where running a compact and 
> repair on a database ended up with RW permissions for the admin 
> account that it was done by, but RO rights for all other users.  I had 
> to  re-set the permissions on the file every time  it was manually 
> compacted.
> 
> 
> --
> Stuart
> On 31 Aug 2011 at 13:07, Darrell Burns wrote:
> 
> > I have an app that's been developed in A2010 on my Windows7 machine 
> > running Office2010 32bit. Autoexec runs a proc called 
> > "AddTrustedLocation" (which I picked up from UtterAccess) that 
> > inserts registry settings to add the app's current database as a 
> > trusted location. I created a runtime with the Package Wizard, 
> > tested it on the same development box and everything works 
> > fine...the registry settings are properly updated and the app opens 
> > into the Switchboard. But when I install the runtime on a different
> > Windows7 machine (also with Office 2010) it crashes on opening. I 
> > confirmed that the folder is trusted via the registry settings.
> > 
> > So I disabled the Autoexec and all the Switchboard startup 
> > procedures. At least the app opens the Switchboard, but now I get a 
> > "This database has been opened read-only" message. I suspect that 
> > this is why it was crashing before I disabled everything. This is a 
> > front-end to a SQLServer database but I do have a few local tables I 
> > use for temporary storage, so read-only is a show-stopper. The 
> > folder it's in has full privileges. I confirmed this by copying in 
> > the accdb version, and it works just fine. What would be the cause 
> > (and remedy) for this condition?
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



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




More information about the AccessD mailing list