How to set Startup Properties in MDE?

[deko]

I'm trying to set startup properties with code after I make an MDB into an
MDE.

I have this code in the startup form's Form_Open event:

If IsItMde Then

For Each var In Array("Perform Name AutoCorrect", _
"Track Name AutoCorrect Info", "StartUpShowDBW indow", _
"StartUpShowSta tusBar", "AllowFullMenus ", "AllowBuiltInTo olbars", _
"AllowToolbarCh anges", "AllowSpecialKe ys", "UseAppIconForF rmRpt", _
"AllowBypassKey ", "AllowShortcutM enus")
Call SetStartupPrope rty(CStr(var), False)
Next

End if

Function IsItMde will correctly identify if it's an MDE or not, and the
properties will get set in an MDB (if I remove the If statement), but not in
an MDE.

Is this because it is not possible to set these options in an MDE? Should I
just set them in the MDB before I create the MDE? Why else would the
properties not set in an MDE?

Here is the SetStartupPrope rty function:

Public Function SetStartupPrope rty(strPropName As String, _
varPropValue As Variant)
On Error GoTo HandleErr
Dim db As DAO.Database
Dim prp As DAO.Property
Dim varPropType As Variant
Set db = CurrentDb
Select Case strPropName
Case "StartupFor m", "AppTitle"
varPropType = dbText
Case Else
varPropType = dbBoolean
End Select
db.Properties(s trPropName) = varPropValue
Exit_Here:
On Error Resume Next
Set db = Nothing
Set prp = Nothing
Exit Function
HandleErr:
Select Case Err.Number
Case 3270 'property not found
Set prp = db.CreateProper ty(strPropName, _
varPropType, varPropValue, True)
db.Properties.A ppend prp
Resume Next
Case Else
End Select
Resume Exit_Here
End Function

[Allen Browne]

The problem is not the MDE. It is certainly possible to set some of these
properties programmaticall y for an MDE.

However not all of these are properties of the Database object.

Some (such as the first one) are properties of the Application, so you to
set them like this:
Application.Set Option "Track Name AutoCorrect Info", False

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"deko" <de**@nospam.co m> wrote in message
news:4P******** ************@co mcast.com...

I'm trying to set startup properties with code after I make an MDB into an
MDE.

I have this code in the startup form's Form_Open event:

If IsItMde Then

For Each var In Array("Perform Name AutoCorrect", _
"Track Name AutoCorrect Info", "StartUpShowDBW indow", _
"StartUpShowSta tusBar", "AllowFullMenus ", "AllowBuiltInTo olbars", _
"AllowToolbarCh anges", "AllowSpecialKe ys", "UseAppIconForF rmRpt", _
"AllowBypassKey ", "AllowShortcutM enus")
Call SetStartupPrope rty(CStr(var), False)
Next

End if

Function IsItMde will correctly identify if it's an MDE or not, and the
properties will get set in an MDB (if I remove the If statement), but not
in an MDE.

Is this because it is not possible to set these options in an MDE? Should
I just set them in the MDB before I create the MDE? Why else would the
properties not set in an MDE?

Here is the SetStartupPrope rty function:

Public Function SetStartupPrope rty(strPropName As String, _
varPropValue As Variant)
On Error GoTo HandleErr
Dim db As DAO.Database
Dim prp As DAO.Property
Dim varPropType As Variant
Set db = CurrentDb
Select Case strPropName
Case "StartupFor m", "AppTitle"
varPropType = dbText
Case Else
varPropType = dbBoolean
End Select
db.Properties(s trPropName) = varPropValue
Exit_Here:
On Error Resume Next
Set db = Nothing
Set prp = Nothing
Exit Function
HandleErr:
Select Case Err.Number
Case 3270 'property not found
Set prp = db.CreateProper ty(strPropName, _
varPropType, varPropValue, True)
db.Properties.A ppend prp
Resume Next
Case Else
End Select
Resume Exit_Here
End Function