How Do I Edit Access 2019 Database Properties

Question

Is there a form for editing the properties that show up when you run:

Option Compare Database

Function ListProperties()

Dim sMessage As String 

For i = 0 To CurrentDb.Properties.Count - 1 

    On Error GoTo lblError 

        Debug.Print i & ": " & CurrentDb.Properties(i).Name & " = " & CurrentDb.Properties(i).Value 

        GoTo lblContinue 

lblError:

        Debug.Print i & ": " & CurrentDb.Properties(i).Name & " = " & Err.Description 

lblContinue:

    On Error GoTo 0 

Next i 

End Function

Answer 1

Properties for the Current database can be set under File>Options.

Answer 2

You can do this through the interface, as Scott suggests.

You could, conceivably, write VBA to do that. You have done the first step already, i.e. identifying properties. But the ROI in a "roll-your-own" implementation might not be all that great. Are there specific properties you want to manage on the fly regularly?

Answer 3

>Properties for the Current database can be set under File>Options.

I don't see where to edit Properties:

Answer 4

>Are there specific properties you want to manage on the fly regularly?

Not really.

Answer 5

>Are there specific properties you want to manage on the fly regularly?

Not really.

Hi saberman,

The problem in Access to do these things "in the user way", is in my opinion, the static behaviour of the forms.

With dynamical forms it is a 3-minute task, but you need an infrastructure to do so.

This functionality is now standard available in all my applications.

More interesting would be to use this kind of overview for only a couple of properties, but then for all the applications, to compare them.

This can easily be done from my "DB_of_Databases" application, using the same infrastructure.

Imb.