---------------------------------------------- That'll Do IT - Database Solutions Properties Setter version 3.5 Copyright (C) Bill Mosca 2001-2006 ---------------------------------------------- Thanks for trying That'll Do IT - Database Solutions Properties Setter for MS Access MDB, MDE and MDA files. This utility allows you to read a database's properties and change their settings without even opening the database. It's fairly simple to use. *****************Installation************************ Unzip the .zip file to your C: drive. It will create the folder "ThatllDoIT" on your C: drive. You can move the folder to wherever you want, but that is where all my stuff unzips to so you might want to leave it there. That's it. There are no reg keys installed or altered, nothing to unistall. If you don't like the utility just delete it. ************************************************ Open PropertiesSetter in MS Access. There are 3 ways to select the files you want: 1) Type the full path in the text box 2) Use the combo box to select one of the 9 recently used files 3) Use the browse button to find the file. If the database requires a workgroup login, use the combo box or browse to the MDW file and choose it. This will open a prompt box to enter the User Name and password of an Admins user. Choose the database whose properties you want to set. Click the Connect button. If the database requires a password, you will be prompted to enter one. After entering the password click the connection button again. NOTE: You will get an error if you try to open a database with a VBA code password. Maybe someday I will fix that, but VBA passwords are pretty much useless so why bother with them. If you create MDE files your code is protected against viewing. You can now set the startup form and select the properties listed. A check means the property is set to True, no check means the property is disallowed. This Utility will also tell you if there is an AutoExec macro. If you tend to use the same settings for most of your databases, you can store settings to be the default by clicking on the button, "Assign Custom Settings". Clicking "Apply Custom Settings" will apply your saved settings. Clicking "Select All" or "Deselect All" does exactly that. Click the Engage button to set the Properties as selected. Click the Open Target while holding the Shift key to bypass the startup form/autoexec macro. This will also close the Properties Setter. Click the About button to see information about the utility, email us or use the hyperlink to visit our site and maybe pick up a couple more of our tools. *****************Version History********************* ***version 3.5*** Fixed a few little bugs, changed color scheme, updated company name, added hyperlink to URL. ***version 3.4*** Added button to open target database ***version 3.32*** Fixed bug in procedure SetDB. ***version 3.31*** Changed code that checked for AutoExec macro. It now uses the database container "Scripts" and document "AutoExec" instead of opening a recordset on MSysObjects. ***Version 3.3*** You can store a list of default settings that can be applied at the click of a button. They can be easily changed in a popup. ***Version 3.2*** added a combo box for selecting from the 9 most recent files. ***Version 3.1*** added an automatic check for an AutoExec macro. ***Version 3.0*** added the feature of getting databases that are share-level secured (database password) and even those that have user-level security...if you know the password. User-level security requires a user ID and password of someone who has administration rights to the database. *****************Disclaimer********************* Properties Setter is Freeware and may be distributed as is. It may not be sold. The author and That'll Do IT - Database Solutions offer no warranty of its fitness for any purpose whatsoever, and accept no liability whatsoever for any loss or damage incurred by its use. ************************************************ If you have any questions, feedback or if you find any bugs please contact me at wrmosca@thatlldoit.com or go to http://www.thatlldoit.com and navigate to Contact page. If you wish to be notified as updates are made available email me at the above address and I will send you an email when the latest version becomes available. I promise to never sell or give your email address to anyone. Not even your mother. Requirements: Access 2000 or higher