Tutorial: Publish a Access 2007 database to the web

Sign in to queue

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

Download

Download this episode

The Discussion

  • User profile image
    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

  • User profile image
    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.

  • User profile image
    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

  • User profile image
    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.

  • User profile image
    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

  • User profile image
    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

  • User profile image
    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?

  • User profile image
    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?

     

  • User profile image
    daverohm

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

  • User profile image
    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.

  • User profile image
    Nicholas Marks

    Addendumbass: Your using Access 2010!

  • User profile image
    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

  • User profile image
    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

  • User profile image
    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 send us feedback you can Contact Us.