ADP and ribbon customisation

[LenRob]

I have an ADP and have tried to create a custom ribbon. The ribbon works ok
in an ACCDB but when I reate the table usysribbons (which gets created on the
SQL server) than i cannot find my custom ribbon in the Access Options/
Current Database/ Ribbon and Toolbar options. The Ribbon Name combo is empty.

Is this because the usysribbons table is on the SQL server so not supported
correctly?

 

[LenRob]

Found the olny way seems to be by writing a bit of code to read from the
table and add the ribbon.
Code looks a bit like

Dim RS As Recordset
Set RS = CurrentProject.Connection.Execute("SELECT RibbonName,RibbonXML FROM
USysRibbons")
If Not RS.BOF Then
Application.LoadCustomUI RS("RibbonName").Value, RS("RibbonXml").Value
End If
RS.Close
Set RS = Nothing

and is run from an Autoexec macro.