Results 1 to 5 of 5
  1. #1
    qvqv is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    18

    Probably Just my stupidity

    I have just come back to a Access project I have not worked upon for some time.



    I definately had a table called 'tbl_Person' .

    A query run against the table tbl_Person returns all the data.

    The table tbl_Person is not listed in the table column of Access nor can it be searched for.

    Please can someone tell me how to get the table back?

    Many thanks.

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    Hi
    Is your database Split into FE & BE ?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    If split, the table icon will have an arrow on it.

  4. #4
    qvqv is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2021
    Posts
    18
    Yes it is split.

    Nas Server with Maria DB

    A query run against the server using Navicat returns

    [SQL] select * from tbl_Person;
    [Err] 1146 - Table 'Family_History.tbl_Person' doesn't exist

    So I wonder where is my table?

  5. #5
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,822
    You need to link the FE to the BE tbl_Person

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

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