Results 1 to 6 of 6

Total Newbie to Sharepoint - Need help migrating Access database to access web app

  1. #1
    ayupchap is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    107

    Total Newbie to Sharepoint - Need help migrating Access database to access web app

    Hi all, hope someone can really help me out here.



    I have two database I use that have previously run from our server but now we want to web-enable them using sharepoint which we have through office 365.

    I see how to migrate the tables but can't seem to work out how to migrate the queries (which i have many of) and the forms. Can someone please help explain how to do this. I am using access 2013.

    Also how do I create a user view that only shows the form views for other users who will be using this database, I want to restrict their access to view the tables.

    As I said before I'm a total newbie with this so any idiot steps or guides etc would be much appreciated, I work at a school doing many things which I am not always specialized in but having to run and upkeep.


    Thanks for any help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,590
    I've never used SharePoint, never built web database.

    This looks like a starting point http://office.microsoft.com/en-us/ac...010131468.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ayupchap is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    107
    Hi there and thanks for your help,

    yes I've been doing some reading and got up and running a bit but can't find anything on migrating queries although I have been told this can be done. If you know of another way of web-enabling my access database also that would be great as well

    Regards


    Scott

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,590
    The only other way I know of involves a lot of web programming with ASP.net or PHP or Cold Fusion, etc.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ayupchap is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    107
    OK wow so thats a little out of my league. I guess it's best for me to just remake those parts then. Thanks for your help!

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,590
    Seems exporting query is same as table http://office.microsoft.com/en-us/ac...001230314.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  2. Access (2013) database in Sharepoint (2007)
    By Yellowboat in forum SharePoint
    Replies: 1
    Last Post: 01-28-2014, 04:58 PM
  3. Replies: 1
    Last Post: 12-26-2013, 09:41 AM
  4. Replies: 0
    Last Post: 06-05-2012, 12:28 AM
  5. Newbie : Need Information on Migrating Data to SQL
    By ebarb in forum Import/Export Data
    Replies: 1
    Last Post: 08-01-2010, 10:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums