The Access Show

Tutorial: Publish a Access 2007 database to the web

Download this episode

Download Video

Description

Access 2010 allows people to publish databases to the web. This is a short introduction by Ryan McMinn that shows you how to check web compatibility, publish to an Access Services enabled server, and create a simple web experience.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • athman

      ok what abt this cenario

       

      i am making access database upload it to the site and developing program using visual studio that can interact with it

       

      is that possible

       

      and if so what is the connection string will be in this case

       

       

      really good work

    • RyanMcMinn

      @athman our tables become standard sharepoint lists. So you can work with them the same way you can work with any sharepoint list in Visual Studio.

    • athman

      and if i am not familiar with sharepoint

       

       

      can u later make video in how to grab data to ur program later in next episodes

       

       

      thnaks

    • ivan_

      Two questions:

       

      - What minimum version of Sharepoint Server is required for this to work?  Our company has only Standard version of sharepoint which does not have business data center, report center and database connections.

       

      - Since Access databases are targeted primarily for semi-professinal developers and power users running small applications, who usually do not have much access to corporate Sharepoint Server, would Local Sharepoint Site Admin permissions be enough for Database Publishing to work? Let's say I am not a Sharepoint admin, just a regular user and have my own user site on sharepoint server which I am an "administrator" of. Would I be able to publish Access Database in this case? I know I can not publish sharepoint web parts created in Visual Studio.

       

      Thanks.

    • ClintC

      @ Ivan_ - Minimum version of SharePoint is likely going to be the Enterprise edition. You simply need the permission to create sites to publish and edit Access Services applications. If you can create a site--you should have the permissions to create apps. Smiley

    • ivan_

      Ok, so it looks like this won't work for us, since we only have Standard not Enterprise Edition.

       

      But you probably looked at how many organizations (and users with in it) are using Standard versus Enterprise and made your decision accordingly.

      Our 40K user organization won't be able to use this feature. Sad

    • wyldKard

      very interesting. with your permission, i'd like to repost this on my blog with reference to your site.

       

      on the other hand, will there be a size limit issue with the access database running online? like the number of open tables, user access etc?

    • daverohm

      Hey, i'd like to do this...But the 'Publish' button is whited out.  Its there but its not active and won't let me press it.  Can you explain what this means and how i can get around it?

       

    • daverohm

      can you email me back at    david.rohm@att       dot    com

    • Nicholas Marks

      Ryan,

      I watched yout video (http://channel9.msdn.com/Shows/Access/Tutorial-Publish-a-Access-2007-database-to-the-web) and noticed your Access has a File tab.

      Can you let me know how to display that?

      In my Access 2007 i just have the standard Home, Create, Database Tools and External Data tabs showing.

      I was hoping to follow your exmaple but without the tab showing I can't do so.

      Do I need something running on my machine such as Sharepoint Server?

      Thanks,

      Nick.

    • Nicholas Marks

      Addendumbass: Your using Access 2010!

    • james

      Hi Ryan, Great Video.
      I have this scenario that i am trying to acheive.
      I have a 2007 database with 6 or so linked tables to allow multiple access the data files.
      It created a trial database to test & it seems that you cannot have a web based form that is part of a kinked table manager.

      Am i doing something wrong? or is this a limitation of web based files?
      PLZ help
      James

    • autoversich​erung rechner ohne anmeldung

      Herself Half,clear area great as the would important describe text love district press distinction mind prefer increasingly future machine fast drop field derive encourage begin evening relate meaning position power that threat half sky actually largely focus meaning noise apparently widely editor thus band note roof assumption serve touch force release corporate phase possibility middle theatre approach cut warn local animal able to neighbour fully remind rock college plenty opposition matter real place means damage certain enter funny trip yes suffer generate play yard form leg base jump board fashion agree note organisation long thank so declare

    • Gabriel C Barkers

      I want to used this ttutorial to teach some students in computer science

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.