Hide "Publish to SharePoint List"

[Nick X]

Hello All,
Is there a way to hide the "Publish to SharePoint List" message bar when I
publish my changes to the production copy on SharePoint? No matter how many
times I tell my users that their data is stored as soon as they move out of
the record, they still ask if they have to click the "Publish to SharePoint
List" button.

Anyone have any suggestions, short of replacing my user base?

thanks,
Nick

 

[Dale Fye]

You could hide the ribbon bar, or replace it with one of your own design.

I generally hide the ribbon bar and replace it with my own menu options in
the header of my forms. This prevents them from doing things the app is not
designed to do.

 

[Nick X]

Dale,
Thank you for your time and your answer. This works to hide the Ribbon:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

But does nothing for the "Publish to SharePoint List" message bar that
appears below the Ribbon once you've started publishing the db to SharePoint.

Thanks,
Nick

 

[Dale Fye]

OK, now I see what you are talking about. When we first adopted Office 2007
and MOSS 2007, I sprang for the ebook - "Integrating Microsoft® Office Access
2007
and Microsoft® SharePoint Server 2007". It really wasn't much help, but did
provide some insight into using Access 2007 and Sharepoint. After you posted
back, I was able to find a screen shot in that "book" which shows the line
you are talking about.

I've got several applications that are using data that is stored on
Sharepoint, but because I exported the tables to Sharepoint, rather than
publishing my application, I don't see the line you are talking about in my
Access application. Have you tried creating a new database from scratch
importing all of your other objects from the original, then link you app to
the Sharepoint tables?

 

[Nick X]

Dale,
thanks for the quick reply. I think what I am going to do is scrap the
whole Online with SharePoint thing. I am waiting waiting for the SQL Server
SA to create me a shell in SQL Server 2005 then I will put my data there. I
am not real confident with the way SharePoint handles data storage, I have
had a couple of instance where data has just disappeared.
Again, thanks for your help in this matter.