I've been playing around with creating my first custom ribbon. I want to
store the ribbons in the SQLServer backend, but Access is not recognizing
the linked table.

1) Can the XML be stored in a linked table or does it have to be a local
table?
2) Can the XML be stored in a SQLServer table?

On Sun, 21 Mar 2010 19:01:30 -0400, "David C. Holley" <David.C.Holley>
wrote:

1: Can be in a linked table.
2: Yes. For example all ADP applications with ribbon would do it that
way. You can use Application.LoadCustomUI to load the ribbon XML from
anywhere.

-Tom.
Microsoft Access MVP


>I've been playing around with creating my first custom ribbon. I want to
>store the ribbons in the SQLServer backend, but Access is not recognizing
>the linked table.
>
>1) Can the XML be stored in a linked table or does it have to be a local
>table?
>2) Can the XML be stored in a SQLServer table?
>

Thanks. I was going to go the ADP route then got wind that MS's official
stance is that ODBC is preferred. Imagine MS backpeddling.

"Tom van Stiphout" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sun, 21 Mar 2010 19:01:30 -0400, "David C. Holley" <David.C.Holley>
> wrote:
>
> 1: Can be in a linked table.
> 2: Yes. For example all ADP applications with ribbon would do it that
> way. You can use Application.LoadCustomUI to load the ribbon XML from
> anywhere.
>
> -Tom.
> Microsoft Access MVP
>
>
>>I've been playing around with creating my first custom ribbon. I want to
>>store the ribbons in the SQLServer backend, but Access is not recognizing
>>the linked table.
>>
>>1) Can the XML be stored in a linked table or does it have to be a local
>>table?
>>2) Can the XML be stored in a SQLServer table?
>>