Bill Mosca's Microsoft Access Database Tools, Code Samples and more for the serious developer.
Home
Access Basics eBook
How To's and Articles
Utilities and Add-Ins
Code Samples
Recommended Books
Misc Downloads & Links
About Us
Contact Us

 
Utilities 
I have developed several tools to make working with Access applications a little easier. I hope you find these freeware utilities useful.
 
 Click the images to enlarge.

Properties Setter version 3.5


My most popular utility by far. This tool lets you connect to an Access MDB, MDE or MDA and see the database settings, startup form and whether or not it has an AutoExec Macro. Think of it as a Startup wizard. 

 
You can change the settings using the Properties Setter without opening the target file. Did you set the database to disallow the Bypass Key? You can reset it. Need to change any of the other database settings? Just check the boxes you want changed. And click the Engage button.
 
View the ReadMe file to find out more about the Properties Setter here.

Add-ins

I started creating add-ins with Access 2000 and got hooked on them. What better way to make life easier than to have more development tools at your fingertips without needing to cut and paste code into each database?

  

Show User Roster version 3.4


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).

 

ShowUsers 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.

 

View the ReadMe file to find out more about the ShowUserRoster here.

 

 

Table Restorer version 1.1


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.

 

As long as you don't delete another object and you don't compact or close the file, you just open TableRestorer from your Add-ins list and click a button.

 

View the ReadMe file to find out more about the TableRestorer here.