-Bill Mosca
On Fri, Oct 1, 2021 at 11:25 AM, Dean Waring wrote:
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_ProfessionalsMS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
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
--
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116066) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
Tidak ada komentar:
Posting Komentar