Results 1 to 4 of 4
  1. #1
    DaveT99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    53

    Changeing to a different Back End Database Office 365

    Has anyone instructions to how to select a new back end database. I am using Office 365
    Previously I had done this many times now the dialogue box has changed in the Linked Table Manager. Have googled but havent found anything suitable
    Regards
    Dave

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,196
    If the tables are all named the same,
    do a relink tables, select all tables, click the select new location box.
    choose the new db.

    it names are not the same, you must start from scratch and import (link) all the new tables in the new db.

  3. #3
    DaveT99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    53
    Thanks, seems easy now, but what threw me was you had a prompt for only 1 table, so when I said yes, got prompts for each table in turn

    Dave

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,067
    That's not unique to the current version of Access. I've had that happen on and off for years but can't recall if I ever figured out why when it did happen.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Replies: 0
    Last Post: 07-16-2018, 03:07 PM
  2. Replies: 1
    Last Post: 01-04-2018, 07:39 AM
  3. Replies: 1
    Last Post: 03-21-2015, 11:55 AM
  4. Replies: 4
    Last Post: 08-19-2014, 12:20 PM
  5. Replies: 4
    Last Post: 05-21-2012, 08:21 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
  •  
Other Forums: Microsoft Office Forums - Senior Forums