The Access Show: Publish a Access 2007 database to SharePoint with Access 2010

GREAT POST Ryann. . . Your last words reminded me of the following. . www.youtube.com/watch YEAh. . i think this functionality will enable a lot of users from arround the globe to succeed in sharing parts of big complex apps in the web. . Some of my apps, will not go to sharepoint because of data size, because of complex procedures in the SQL, and share point will not go there, but thats another topic. NOW. .with this functionality we can have parts of our apps to go public, and allow for more data entry options, and even share results with some users arround the globe. . Now, we have the best of both worlds. .

Hey peter from Germany, rob cooper from Seattle. .

Those access developers that still play guitar . . comment isn't this a great video.

I get the following when I try to access the help article Server Error

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

As an small side note. Should this not read publish an 2010 database to sharePoint, not 2007? Albert D. Kallal...

@albert - Tweaked the title a little to be mroe clear. Thanks. @grovelli - fixed the link. Sorry about that.

Ryan, after publishing the database to Access Services, why does the single tab "Task List" on the client become two tabs: "tasks_demo" and "Options" on the published database?

@grovelli in the browser all databases have a master heading section as part of SharePoint. This holds the site logo, title and options menu (open in access, share the site) and shows which user is logged on.

So you need to be conversant with Sharepoint in order to prepare the master heading section?

Hi Ryan, What a great and timely video! This clears up some of the questions I have, thank you I published my first Access database to the web yesterday ... wish I had checked this blog and seen your video first (smile) -- now I've watched it a few times I was only trying to publish tables. I wondered why the control name column was in the compatibility issues report (which naturally I got). In your example, you point out the CONTROL name with % was not valid on the incompatibility report... yet you changed a table to fix it ... why? My database only had tables ... but after 3 strikes, I was *in* (smile) My tables had relationships -- which all need to be deleted? hmmm, well it did say relationships were created using lookup fields so I made one using my Countries table. Its primary key is the standard 2-character country abbreviation. My Countries table had a primary key when I imported it ... or at least I thought it did. I did not know the primary key got removed (since it was a text field?). There is no indicator for primary key (the key is such a familiar symbol... where is my warm fuzzy blanket? )... so this was a bit confusing in my web issues report: "Table 'Countries' used as the lookup row source must have a primary key" My first thought was, "it does!". What is the recommended way to add a primary key field to a table? ... and then change the foreign key in other tables to use it instead of what they have? Obviously, the best solution is to do all this in the client database before importing tables into the web database ... but what if you have already set up other things that you don't want to lose?

Maybe you can do a video on this? ~~~ site name -- After I published to SP, I either did not notice or did not get the specific URL for my database ... if I did, maybe I subconsciously skipped over it because it started with the site I provided ... for whatever reason, using a different URL for the database than my account didn't click (like it should have). To see what was on SharePoint, I went to the URL for my account at AccessHosting.com (which is nice to have, thank you), not the specific URL for the database site. I had to click around a bit until I found my database. Is there an easy way in Access to see the site name the db is published to and be able to copy and paste it -- or even better, how about a clickable link somewhere? Now I notice the tooltips, which are nice to see for a few times, but you can't click on them (or can you?) ~~~

When you demonstrate Publish to Access Services, will you explain the difference between the Server URL and the Full URL ... and why we see both of them? ~~~ How do you make a client object like an update query in a web database? I ended up linking to the tables and doing it in another database -- is there a better way? ~~~ Is the datasheet form you made viewable on the web by itself or must it be on a navigation form? Thanks, Ryan :) Warm Regards,

Crystal * (: have an awesome day :) * p.s.

Publish aN Access 2007 database to SharePoint with Access 2010 or...

Use Access 2010 and SharePoint to Publish an Access 2007 format database to the web

? ;)

>Is there an easy way in Access to see the site name the db is published to and be able to copy and paste it Ctrl-g

Debug.print currentProject.Website If your are creative, I suppose you could/would add an custom ribbon option that does an Application.FollowHyperlink currentProject.WebSite. (thus, you would have an ribbon button for all applications that you just whack to launch your web site). I smell an tips article! More hints:

In the final published “ok” screen (2:20 time in Ryan’s above video) does have a hyper link you can click on to jump right to the site (but, you only get this the first time you publish) Another quick way to get the path name is to simply hover your cursor over a table in the nav pane in the client. You will see the url in the tool tips help. If you like me, you likely forget what sites you created while having so much fun. You can view/see/get an “list” of the sites you created on the SharePoint side. Type in your based URL you have for access hosting. (Usually the recent history url in your browser will remember if you been playing…just type in a few chars of your site (leave out the www. part). The browser autocomplete should always thus bring up your base SharePoint site…select that. (for officelive, I have a permenant link on my desktop, perahps the same for this hosting is a good idea). Now on the left nav pane (web site), the last option is “All site content” Click on that option….scroll down to the bottom of web page…you see an list of Sites and workspaces. You can click on any of these to launch one of what is likey many published sites. You can also add these sites to the nav bar across the top of your SharePoint base site, but, lets keep this post short..

@Albert Thank you for responding. When it comes to new technologies related to Access, you are a great explorer. I am inspired by your discoveries of the "treasures" and appreciate the time you have taken to share your explorations of Access 2010 and Web Services with the Access Community through your videos and your posts. Your contagious enthusiasm and perspective has opened up a whole new way of thinking. You are truly gifted at seeing the silver lining and the best there is, thank you, Albert. > Debug.print currentProject.Website ooh, great tip, thanks! > I smell an tips article! ... and/or a video? > In the final published “ok” screen (2:20 time in Ryan’s above video) does have a hyper link you can click on to jump right to the site (but, you only get this the first time you publish)" thanks, Albert -- the next time I publish the "first" time I will be looking! > Another quick way to get the path name is to simply hover your cursor over a table in the nav pane in the client." thanks. I saw this -- too bad it isn't clickable ... or copy-able "You can also add these sites to the nav bar across the top of your SharePoint base site, but, lets keep this post short.." well now you can make a response (smile) ;) @Ryan & Clint this contest was a great idea! ... how to coordinate timely feedback from those who want to be involved in test-driving and helping design the future ......not only the beginning of a new year ,,, but a new decade ,,, I see Access 2010 and web services as the first baby steps to the future. Those that learn it now have a great advantage. Thank you for asking us what we think and giving us a chance to help shape what lies down the road. Warm Regards,

Crystal * (: have an awesome day :) *