Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Question Linked Table Manager Problem

    Please help,

    I am trying to copy my front end and back end into a new folder for learning purposes. After copying both to a new folder on my hard drive, I try to use the link manager to update the links to the new copy of my back end instead of the remote server. There is one table and it's form that will no longer work after doing this. It is the largest table (our main data entry). It gives me the Microsoft Access is experiencing a problem and needs to quit window. All other tables and forms work fine.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried a Compact and Repair? Does the original work correctly?

  3. #3
    Join Date
    Aug 2009
    Posts
    3

    Reply

    I have tried the compact and repair after I copy the front end and back end over. Both of the originals are working fine. I have also tried removing all the linked tables and importing them.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried importing the tables into a new db? I would try it with the FrontEnd as well.

  5. #5
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Here is a link http://www.access-programmers.co.uk/...d.php?t=170607 to a sample mdb that toggles between live an training during login.

    David

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

Similar Threads

  1. Query on a linked table?
    By SilverSN95 in forum Queries
    Replies: 1
    Last Post: 09-26-2009, 03:00 PM
  2. Linked table to sql 2000 db
    By tcroninstl in forum Access
    Replies: 1
    Last Post: 03-23-2009, 07:27 PM
  3. Using Linked Table Manager --Can't get it work
    By cccgsmith in forum Access
    Replies: 6
    Last Post: 03-11-2009, 06:43 AM
  4. Editing a Linked Table
    By amndza in forum Access
    Replies: 2
    Last Post: 01-21-2009, 01:27 PM
  5. Linked Table Manager
    By driccardi in forum Access
    Replies: 4
    Last Post: 02-15-2006, 11:47 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