Know how to hide ribbon in Access ADP?

[amarkmac]

I am quite familiar with how to customize or permanently hide the ribbon in ACCDBs, using the USysRibbon table and XML code. Unfortunatly, I am now working with an Access Project (ADP) frontend interfacing with a SQL server. As you may know, ADPs can not have local tables -- all tables must reside on the server. The SQL system table structure is quite different. While ACCDBs have MSys tables, ADPs have SYS tables, and there is not a one-to-one correspondence with just different name prefixes. I've tried to create a USysRibbon table on the SQL server, but Access doesn't see it.

Anyone run into this or seen anything on the forums about it? I've searched for many hours today to no avail.

Thanks,
Mark

 

[NigelShaw]

hi,

I thought I read somewhere that 2007 didn't have adp but I could easily be wrong. You can load a ribbon from a word file instead of a table. I will dig out how to do this later and post it.

Regs

Nigel

 

[amarkmac]

Thanks, Nigel. You can definatley develop ADPs with 2007 and they've added a lot of neat new features around it.

A user on another forum replied with a good lead ( http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1720391 ) that I'm pursuing now, so hold off on digging out the Word approach. If his lead doesn't pan out I'll let you know.

Thanks, again.
Mark