Results 1 to 3 of 3
  1. #1
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19

    Adding/editing/deleting data from Access 2013 database via browser?

    Hello,

    I have access 2013 offline desktop database (DB) created for everyday business (materials managament, sales etc). I have approx. 50+ forms/tables/reports.
    I plan to put one part (5%) of that DB online. That 5% is component called „Purchase orders“. In order to do that, few tables which are connected to component „Purchase orders“, I decided to convert that tables to sharepoint list, and then create Access 2013 Web App with linked tables from sharepoint list.
    Then I have found that it is IMPOSSIBLE to add any new data via Access Web App 2013 because tables are linked to sharepoint list?! It is ONLY POSSIBLE however, to add new records directly editing sharepoint list which sucks hard!



    Since my plan to put few tables from my DB to online using only sharepoint lists and Access Web App is ruined by very unpleasant surprise from Microsoft, I am trying to figure out how to convert few of my tables connected to component „Purchase orders“ online (via browser), but same tables must be still available for adding/editing data from offline DB. I guess that is possible if I migrate all of my tables to MSSQL server DB and than to single out all tables from component „Purchase orders“ and put them to use via browser using ASP.NET or similar.

    Any help is appreciated because I am stuck
    Thank you.
    Adi

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Data enabled web site is not simple. I did some experimenting with Access db, ASP, ColdFusion, IIS few years ago. Can't remember much except it was challenging. Never implemented anything mostly because too many bureaucratic hoops to jump through.

    Has been topic of several threads - did you search? Here is one https://www.accessforums.net/access/...via-39095.html
    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
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Agree with June7 (and apparently, your experience). SharePoint lists have never impressed me as a viable data source for Access use. You could consider Excel workbooks or similar formats that Access can 'read' (such as csv files) that are edited and saved in a SharePoint site but link to them from Access by the full path name. The files have always afforded me much more usefullness than any list.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 9
    Last Post: 11-22-2015, 11:19 AM
  2. Replies: 2
    Last Post: 02-07-2015, 11:20 PM
  3. Replies: 5
    Last Post: 09-28-2013, 05:48 PM
  4. Replies: 4
    Last Post: 08-21-2013, 07:08 AM
  5. Replies: 1
    Last Post: 03-05-2013, 02:37 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
  •  
Other Forums: Microsoft Office Forums