Logo

MS Access FAQ - Security

 Logo

Table of Contents (2 Questions)

Bullet Preventing the AutoExec Macro
Bullet Changing the owner of a database

Q How do I prevent the AutoExec Macro from Executing?
Back to Top
A In Access 2.0 you can hold down the [Shift] Key while the database is loading.

In Access 97, you can use the "NOSTARTUP" switch, e.g.
MSACCESS.EXE" /NOSTARTUP "C:\database\mydb.mdb"

Updated: 21/12/1997 - Trevor Best

Back to Top
Q How do I change the owner of a database?
Back to Top
A You can't change the owner of the database, the owner is the user who created it.

What you can do is create another database while logged in as the user you want to have as the owner, then import the database you want to change the owner on.

For this, select the 'File' menu, then 'Add-ins', then 'Import Database'

Tip: Using the "Import database" option will also import any relationships so this is better than making a new database and importing each object individually.

Updated: 03/10/1996 - Trevor Best

Back to Top