Re: [MSAccessProfessionals] Lockdown

Where can I find PropertiesSetter utility imentioned in this email.

 

Thank you

Dean Waring

 

Sent from Mail for Windows

 

From: Bill Singer
Sent: Thursday, September 23, 2021 2:26 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

I have not had a chance to track this down, however I do not have an Auto Exec. 

Thanks for the help.

 

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Thursday, September 23, 2021 1:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

Hi Bill & Duane

 

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

 

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx  By the way, this add-in has been my go-to for 20 years. Too many features to list here.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

 

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function. 

 

Duane

Sent from my mobile

 

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:



 

I have a module called Lockdown which locks down a lot of properties from an end user.  It appears to run on database startup.  I put this in a few years ago and now I want to remove it.  How do I keep this from running upon start up?  I am guessing if I just delete it there will be issues.

 

Bill Singer

Microsoft Office 365

Windows 10