Results 1 to 2 of 2

MS ACCESS 2007 and SHAREPOINT

  1. #1
    Prega is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2019
    Posts
    1

    MS ACCESS 2007 and SHAREPOINT

    Hi guys,
    I am really old school. I have worked with MS Access 2000 (Time of inception) up to MS access 2007.
    I now own a small business and my accounts database is still in MS Access 2000 (inherited when I bought a business in 2001).


    I could not upgrade the DB due to its VBA modules all being password protected.

    My business is growing, and I now want to create 3 FE and 1 BE over the WAN.

    Upon researching, Sharepoint seems to be the most appropriate option to set up the BE on the Cloud.

    Upon researching Sharepoint, Microsoft . I don't want to change Office.

    I want to trial Sharepoint, but Microsoft is forcing Office 365 as a trial. We are still using Office 2007.

    Any suggestions?


    Thank you in advance

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    5,713
    forget back end on the cloud/One Drive/WIFI - anything like that. It is a recipe for db corruption. If WAN, db part had better be wire connected.
    Support for Access/SharePoint is on the way out.
    AFAIK, you can buy Access 2016 off the shelf (no 365) but if dumping the SharePoint idea, 365 could still work for you. 2007 is getting a bit old for starting up a new app.
    MS Access 2000 (Time of inception)
    Hardly. 1.0 came out around 1992.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

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

Similar Threads

  1. Access (2013) database in Sharepoint (2007)
    By Yellowboat in forum SharePoint
    Replies: 1
    Last Post: 01-28-2014, 04:58 PM
  2. Access 2007 Runtime mode & Sharepoint list
    By PuJo in forum SharePoint
    Replies: 0
    Last Post: 07-31-2012, 05:16 PM
  3. Replies: 0
    Last Post: 06-19-2012, 12:39 PM
  4. Replies: 3
    Last Post: 05-30-2012, 01:43 PM
  5. Access 2007 to SharePoint
    By tcheck in forum SharePoint
    Replies: 0
    Last Post: 08-09-2011, 08:07 AM

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