How to remove ULS from MS Access split mdb

Posted on 2007-08-09
Last Modified: 2013-11-29
So, i secured my Access mdb today, and everything went fine, except that is slows development down to an utter crawl.  It seems that now everytime i try to make a change to any VB CBF i have a 10 second delay that i only assume is Access checking whether or not i have the correct permission on the object i'm messing with.  Since the DB is not yet in production and i still have a good ways to go on it, does anyone know how to UN-apply user level security to an MS Access .mdb?
Question by:zhenchyld
    LVL 26

    Accepted Solution


    Author Comment

    ha ha !  i'll try that first thing tomorrow.  I'm glad i asked, becuase that sounds a whole lot easier than anything i was going to try.
    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Generally ULS won't cause slowdowns. I use it on almost every project, and have never noticed a performance problem.

    Are you sure you aren't experiencing delays from something else? This almost sounds as if the Name Autocorrect feature is enabled. You can (and should) disable it via the Tools - Options menu, General tab (uncheck the Track Name Autocorrect info setting).

    Author Comment

    LSM - name autocorrect is on because the first thing i did with this db was run through and rename everything according to a naming convention.  it hungs up for about 5-10 seconds every time i start to edit any VB; it's ok if i'm in a form and hit 'design view' and go to properties and go to 'on update' and edit the code like that, but when i Alt-Tab back and forth between teh VB editor and form view (which i do CONSTANTLY) or when i scroll down and start to edit another event or a public function or what-have-you i get the 5-10 second pause.  it started immediately after i implemented ULS; i thought maybe it was becuase the WorkGroup file was on the server with teh backend of things but even when i point Access to a local version of the workgroup file i get the same behavior.

    anyway i'll kill name autocorrect and then import everything into a new db and see if that helps.  thanks for the tip regardless as Name Autocorrect seems to be a pretty crappy feature anyway ( and i was not aware of the problems it could pose.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now