{"id":1198,"date":"2016-06-01T21:57:55","date_gmt":"2016-06-02T01:57:55","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?page_id=1198"},"modified":"2022-02-27T16:05:32","modified_gmt":"2022-02-27T21:05:32","slug":"access-tools-utilities-and-more","status":"publish","type":"page","link":"https:\/\/regina-whipp.com\/blog\/?page_id=1198","title":{"rendered":"Access Tools, Utilities and more…"},"content":{"rendered":"
It dawned on me there is no place where one could go to get a list of *mostly* free tools to use with Access.\u00a0 Below is\u00a0a compilation of those tools, utilities, add-ins and more\u00a0to make your database development easier.<\/p>\n
Note: MVP logo means created by an MVP (past and present)<\/em><\/span><\/p>\n
Tools, Utilities and Add-Ins (to help with your database development)<\/strong><\/p>\n
A Microsoft Access Add-In that reveals the dependencies between database objects like tables, queries, macros etc. and helps to maintain and clean up your MS Access databases<\/td>\n<\/tr>\n
This is the PowerPoint slideshow that Armen Stein, President of J Street, presented to the KEGS Access SIG. It shows how to tackle the problem of converting old \u201cflat\u201d data (from Excel, text or wherever) to your relational Access tables. Includes a sample database showing the techniques mentioned in the slides.<\/td>\n<\/tr>\n
A sampler of labor-saving code and cool usability enhancements. Includes Quick Date, a \u201cQuicken-style\u201d method of using keys to increment date fields by day, week, month and year, and some handy name and address concatenation functions. Comes with a form demonstrating most of the tools \u2013 look in the code for more!<\/td>\n<\/tr>\n
Access 2007 saw the introduction of the Navigation Pane. \u00a0 For those that prefer the Object Container you can use this Add-In to get it back.<\/td>\n<\/tr>\n
Find and Replace is a add-in for all current versions of Microsoft Access to find (and replace) a term in the design time properties of any Access object (tables, queries, forms, reports, macros, modules).<\/p>\n
It is an invaluable tool for Access developers to navigate sizable Access projects, to analyze unfamiliar projects and to quickly rename or change properties and code across the whole project or parts of it<\/td>\n<\/tr>\n
We took what we humbly think is the best Access table relinking code and made it even better. This beta version has all the features of the original J Street Access Relinker, plus it now supports 32-bit or 64-bit Access AND encrypted (password-protected) back-end Access databases! Give it a try and let us know if you run into any issues. Tested for Access 2010, but should also work in earlier versions. There\u2019s a READ ME table with detailed instructions<\/td>\n<\/tr>\n
Have you ever needed to change a part of your project, for instance how one or more fields are designed in a table, but aren’t sure which parts of your project are referencing these items? Worried that some very rarely used part of your project will be broken by the changes you’re preparing? You are not alone!<\/td>\n<\/tr>\n
This little gem of a utility is something I wrote back in the Access 97 days and I won’t develop a database without even today! \u00a0What the utility does is pretty simple: It will tell you all the objects and properties a string pattern exists, and with some object types (Forms, Reports and Queries) you can do an “Edit and Continue” to change a property with the searched pattern. \u00a0There are a few paid apps out there that to similar tasks, but this one is all Access (it\u2019s a single form that you import into your database), plus it\u2019s free!<\/td>\n<\/tr>\n
This is an Access Add-in that is meant to be used in the back end of a split database that utilizes Access User Level Security (ULS). It can display a list of all current users in the database, telling you which ones are suspect (may have not exited properly and hung the LDB file).<\/p>\n
Show Users has the functionality to let you block any new users from opening the database, and there is a built-in messaging feature that asks logged in users to log out.<\/td>\n<\/tr>\n
Ever accidentally delete a table? ACK! I hope you have a backup. Nah, you don’t need a backup. You can restore the table with this add-in.<\/td>\n<\/tr>\n
A pack of nice and useful tools to enhance your development. Those tools are available from the menu “Tools”, “Extensions”. (Is it also has a VERY powerful searching tool.)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
When an error message is generated finding out exactly what the User was doing is not always easy, so, finding the source of error for debugging is very difficult. This tool will make that task 100% easier!<\/td>\n<\/tr>\n
A MSForms (all VBA) Treeview *Control*<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Odds & Ends<\/strong><\/p>\n
\n\n
\n
<\/td>\n
<\/td>\n
Problem Steps Recorder<\/strong><\/td>\n
This can be found in you System32 folder, file name psr.exe. \nGreat for when your Client reports a problem you can\u2019t duplicate. \u00a0 You can have them open this up, press the Start Record<\/strong> button perform the task and then press Stop Recording<\/strong> then they just eMail the file to you.<\/td>\n<\/tr>\n
![\"Filtered\"](\"http:\/\/regina-whipp.com\/blog\/wp-content\/uploads\/2016\/06\/free24.png\")
<\/td>\n![\"Filtered\"](\"http:\/\/regina-whipp.com\/blog\/wp-content\/uploads\/2016\/06\/MVPLogo16.jpg\")
<\/td>\n