MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Access-specific code

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

Leszynski-Reddick Guidelines	The Leszynsk-iReddick Guidelines for naming Access objects.
Shutdown an Access app	How to shutdown an Access application from code.
Create a new blank database	Code for creating a new Access database.
Database Window	Code for displaying/hiding the Database Window, & for detecting if the Data Window is made visible.
Detect application close	Detect when an application is closed.
Flash the Access Application Window	Function for flashing the Access application window.
Full list of all RunCommand Constants	Just as the title states.
Access Version	How to get the version of Access.
IsMDE & IsRuntime	How to find out if the database is an MDE, & whether it's running in the runtime environment.
Allow/deny user connections	An easy way to deny any more connections to an Access database.
Open a ULS-secured Access applicaton	How to open an Access database that is secured by user-level security (ULS).
Open a database secured by a password	How to open an Access database that is secured by a database password.
Open a database without firing the AutoExec macro	How to open an Access database without firing the AutoExec macro.
Deleting hidden objects	How to delete all hidden Access objects, like tables, queries, & so on.
Using privDBEngine	Using the privDBEngine object.
Access hInstance	Getting the Access hInstance
Access file type	Determining the Access file type (mdb, mde, adp, ade)