Re: Question on Albert's video regarding A2010

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message

Can you publish a mixed database to Sharepoint, such that the web
parts will be available to web users and the client objects only to
client users?

For the web side, it easy since launching it from a web browser, they only
going to see the web based objects.

However, on the client side, it's a little bit more interesting. Your code
(VBA or macros) is free to launch client only forms or web forms. In fact,
you can simply launch by a double click on any object in the NAV pain
including those web based forms. When you launch a web based form inside of
the access client, then the access client launches that web form just like
any other client form that is local. So, web forms can be launched/used both
web side and client side in your applications. Remember, they all be using
data from the SharePoint site...

Of course in the startup options, now have two options:

web startup form
client startup form

So, if you hide the ribbon and specify a VBA client form in the client
startup, your users will not see the nav pane, and thus will not be able to
click on/launch the web forms.

What it sounds like to me is that you can now do this in a single
Access app. And anything that's shared functionality between the two
application versions (the customer version vs. the employee version)
could be web forms.

Yes, above is correct.

The only real part I miss here is that you can't have ANY local tables in
the client app. So, you can have client forms, client reports, client query
etc. However, you CAN link to an external mdb or external accDB files that
sits on your local pc (or to a network share). So, you can have local data
here, but NO local table in the actual web application is allowed (so, we
don't have client tables, or web tables..they are ALL web tables). Hence,
any local physical table in the "web" app will become a SharePoint table
when you publish for the first time.

However, linked tables to local data is permitted in this web application.

Assuming I've described things correctly, can you have web objects
that *don't* get included when you publish to Sharepoint? Or is it
all or nothing (i.e., all web objects get published or none)?

It is "all" of them go up to SharePoint. So, all webobjects will get
published. No choice.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages