Results 1 to 3 of 3
  1. #1
    Gina Maylone is offline Always learning
    Windows 10 Access 2016
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Removing linked tables before updating front end causes broken queries

    Good morning!

    When I update a front end, I remove the linked tables from the db. When it's on the end user's machine, I relink the tables to the ones on their shared drive. When I click a button on the menu to open up the Members form, I get errors, prompting for the MemberID (the first field in the recordsource), the query behind the form shows Expr1: memberID, Expr2: lotnum etc. for all of the fields. How do I avoid this and still send a clean front end?? TIA!

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Make sure you do not open any queries when the links have been removed.
    Another solution is to change all your queries to SQL view and then save.
    Once you have all the Expr1/Expr2 etc fields all you can do is remove the Expr part manually or start again with a fresh copy
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Gina Maylone is offline Always learning
    Windows 10 Access 2016
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Yea, I was thinking of doing the SQL thing. And yep, I'm painfully aware of manually retyping ;-) THANK YOU Ridders52!

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

Similar Threads

  1. Replies: 1
    Last Post: 10-08-2015, 09:15 AM
  2. Changing Tables Front-End DB are Linked To
    By JoeM in forum SQL Server
    Replies: 8
    Last Post: 03-31-2015, 11:09 PM
  3. Replies: 4
    Last Post: 11-22-2013, 11:20 AM
  4. Linked tables not updating
    By ABQcook in forum Access
    Replies: 1
    Last Post: 01-04-2012, 01:27 PM
  5. Auto-updating fields in linked tables?
    By Leelers in forum Database Design
    Replies: 27
    Last Post: 01-08-2010, 06:23 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