Results 1 to 3 of 3
  1. #1
    tsloan is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2015
    Posts
    1

    Database to share point can i make it work


    So I am wanting to upload my Databse to share point. This is what I have I am working with.

    So I have 4 linked tables to excel - data updated daily
    then I have several fixed tables in the database
    So what it is is sales data and inventory data for several locations.
    I have combined this data all together using union quireies and a final quirie pulling it all together
    The final quiry is pulled back into excel where I have bulit a pivot table as a tool to sumarise the data.

    The reason I want to use share point is so that I can have multiple users update the 4 linked tables and refresh the final excel table.

    Will this upload to sharepoint and work? I have read that Union Quiries don't work in share point

    If not do I have other options?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    If all of the users are on the same LAN network I would suggest implementing an Access Desktop Database and split the database as a front end and a backend.

    If you use Access to share data via SharePoint, you will need to create an Access Web Application. I do not know much about Access Web Applications. So I cannot offer any advice on how to create one.

  3. #3
    bigot is offline Advanced...ish
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    37
    ItsMe's suggestion is probably the easiest solution. However, a shared .accdb back-end is sooooooo slow.

    I've not used Sharepoint, but you should be able to union Sharepoint lists (they call them something different, look up "Combined View"). Another option (which I love) is an SQL back-end. You can create views (equivalent to queries) in there, and use SQL to do so.

    Depending on the type of SQL back-end (MSSQL, MySQL, etc) and the version of Access you have, you may need to download and install an ODBC driver on each of the computers using this database. This is annoying if you have different versions of access on the computers.

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

Similar Threads

  1. Share Table across different Database
    By trident in forum Access
    Replies: 2
    Last Post: 12-02-2014, 05:49 AM
  2. Reading Excel file from Share point
    By selvakumar.arc in forum Import/Export Data
    Replies: 1
    Last Post: 03-27-2014, 02:00 PM
  3. Replies: 17
    Last Post: 04-24-2013, 12:58 PM
  4. The easiest way to make a point of sale
    By eskybel in forum Queries
    Replies: 79
    Last Post: 11-20-2012, 07:30 AM
  5. Share a database over the Internet
    By edupi in forum Access
    Replies: 5
    Last Post: 04-13-2009, 08:14 PM

Posting Permissions

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