Deactivate MDB Conversion Wizard? 2

[jlodge]

Has anyone been able to have Access 2003 NOT open the MDB conversion wizard? We are a large organization and we can't just convert all the Access MDBs and rollout Access 2003 overnight.

We would like to convert and rollout department by department and would like to have Access 2003 "default" to just view Access 97 mdbs without converting them. After rollout is complete, we'd like to activate the wizard.

 

[easyit]

I believe that you ar looking for the option menu under extra, select the tab advanced and select as default acces2000 instead of access 2002-2003. I dont know the right english words in these menus - goto a dutch version of access.

 

[RoyVidar]

Have a look at this article How to suppress the Convert/Open Database dialog box when you open an Access 97 database

Roy-Vidar

 

[smedvid]

You can most likely set the value via code using Application.SetOption. I typically force the Delete Confirmation ON as a precaution.

....
Private Sub Form_Open(Cancel As Integer)

ApplicationUtilities.AccessMaximize
ApplicationUtilities.HideAllMenuItems 'Prevents USer from Entering Right Mouse for Design Mode!

If AutoExec.LoginCheck() = False Then 'Check NT Authority to Use Tool.
DoCmd.Quit
End If


'Set Confirm Changes to True - Used for Deletes
gcOriginalOptionState = Application.GetOption("Confirm Record Changes")

Application.SetOption "Confirm Record Changes", True


...



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...