I use an Access database to populate my XML details for a Word template Ribbon Bar.
This is the code that I use to access, in this case, the Labels for the various buttons, etc on the Ribbon:
If I were to password protect my Access database to stop people editing it, can I put a password in my code somewhere that will allow it to read the data which feeds back into the XML?Set dbRibbonData = OpenDatabase(Name:=inifileloc2) 'searches the Registry for the set language myLanguage = GetSetting("GA", "Template Language", "Language") 'search the database in the 'Template_Labels' table in the 'language' field for the 'control.id' record strSQL = "Select " & myLanguage & " FROM [Template_Labels] where [Field_Code] = '" & rxMyLabel & "'" Set rdShippers = dbRibbonData.OpenRecordset(strSQL, dbOpenDynaset) 'return the value back to the Ribbon XML On Error Resume Next returnedVal = rdShippers.Fields(0) rdShippers.Close dbRibbonData.Close




