Solved VBA to Set 'Show this number of Recent Databases' option to 0?

[Mohsin Malik]

Hi,

Is there a way to set the Show this number of Recent Databases and Quickly access this number of Recent Databases options to 0 in Microsoft Access using VBA. Is there a correct way to set these values using VBA. Our goal is to prevent any recent databases from showing up in the list or being quickly accessible.

Thanks in advance!
Mohsin

 

[Edgar_]

Get the number:
MsgBox Application.GetOption("Size of MRU File List")
Set the number:
Application.SetOption("Size of MRU File List"), 0

 

[Mohsin Malik]

Get the number:
MsgBox Application.GetOption("Size of MRU File List")
Set the number:
Application.SetOption("Size of MRU File List"), 0

Perfect, thank you!