Results 1 to 3 of 3
  1. #1
    rbienko is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    1

    Table link issue

    Hi,


    I have quite unusuall issue, at least for me
    I have created a database which has been moved to another folder when it was finished. After that the problem has started. One table (linked to new destination) is trying to connect to the folder where the database originally was created. The folder is empty and there is no impact but when I change the name of the folder or delete there is a message saying that cannot connect to the database in the folder.
    The most funny thing is when I create query based on this table selecting all columns one by one it works fine but when use * to retrieve all rows the problem is back.
    I have gone through every piece of the database and I can't find anything what could make the table to connect the folder.

    Thanks in advance for any help

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is your application split into FrontEnd and BackEnd? Are they both in the same folder? Maybe this link can help: http://allenbrowne.com/ser-13.html

  3. #3
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    in addition to Allen Browne, why can't you simply open the linked table manager and change the linked BE folder? It shouldn't stop you from doing that...

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

Similar Threads

  1. Subform Link Issue
    By danhartman in forum Forms
    Replies: 7
    Last Post: 07-06-2010, 07:14 AM
  2. link sql server table to access
    By broken_ice in forum Access
    Replies: 0
    Last Post: 06-28-2010, 12:50 PM
  3. Replies: 1
    Last Post: 06-14-2010, 03:01 PM
  4. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM
  5. Import/Link Pictures into a table
    By shm138 in forum Import/Export Data
    Replies: 3
    Last Post: 03-17-2006, 08:12 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