Results 1 to 4 of 4

Thread: Sharepoint & MS Access

  1. #1

    Thread Starter
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Sharepoint & MS Access

    I have been asked by work to develop a web site which allows the update and viewing of an Access database (unfortunately MSSQL is not an option they are willing to consider so I am stuck with access).

    In addition, I have also been asked to publish the site on a sharepoint site on the Intranet. I was shown by another employee how I could drag and drop the database onto Sharepoint and how I could create my own "web page" with some rudimentary HTML code to do things like embolden and italicize text on the page. I am a little concerned that this does not meet the requirements of the task in hand

    As I have very limited experience with Sharepoint I am unsure exactly what it is capable of. A couple of colleagues have hinted that it can do a lot more provided I am supplied with the appropriate access rights. However, I have a sneeky feeling that the interfacing with Access databases may be somewhat limited if it exists at all.

    The most obvious solution to me would be an IIS server with a small ASP.NET front end which talks with the database. But, if sharepoint already has these capabilities then there is no point wasting my time re-inventing the wheel.

    Can anyone give me an indication as to weather or not this is a feasible idea and if so; what level of customization one would have?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Sharepoint & MS Access

    This article might help a little.

  3. #3

    Thread Starter
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: Sharepoint & MS Access

    Thanks Hack. That article seems to be the opposite to what I need to achieve as it describes how to use Access as a front end with Sharepoint as the data provider.

    From what I understand Sharepoint runs using ASP.NET; does this mean that one can write addons or extensions to the interface using .NET?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Sharepoint & MS Access

    Quote Originally Posted by visualAd
    From what I understand Sharepoint runs using ASP.NET; does this mean that one can write addons or extensions to the interface using .NET?
    Yes; at least I believe so.

    The people running the Sharepoint thing at this company are creating department specific setups using ASP.NET - at least that is what their newsletters are saying.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width