Results 1 to 3 of 3
  1. #1
    RunTime91 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Posts
    284

    Trying to determine how a table is populated with data

    Greetings...



    This is a mystery to me hopefully not for you folks here...

    I am tasked with moving an Access db from a local desktop to a Virtual Desktop...

    The db has a few linked tables and here is where my dilemma begins

    I have found the source table which is a local table in a seemingly random db.

    however the db has no forms so I have no idea how this table is populated the data it use to feed the table in the db I'm trying to move over to VDI??

    Is there a way to find out how this table is populated with data?

    Thank you!!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    if there are no forms, nor queries,etc.....then this is the backend db.
    If you move the db to another folder, then all the users will tell you where they are, because their frontend will no longer work.

    If this db is the frontend, (without any forms) then data is either entered via tables, or an import function.

  3. #3
    RunTime91 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2014
    Posts
    284
    Quote Originally Posted by ranman256 View Post
    if there are no forms, nor queries,etc.....then this is the backend db.
    If you move the db to another folder, then all the users will tell you where they are, because their frontend will no longer work.

    If this db is the frontend, (without any forms) then data is either entered via tables, or an import function.
    RanMan... You're brilliant!... Yes! This is a BackEnd!! (I did not understand the significance of that or what it meant until now)... RanMan, Can't Thank You enough!!

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

Similar Threads

  1. Replies: 3
    Last Post: 05-24-2016, 09:02 AM
  2. Determine the Primary key within a table using VBA
    By crowegreg in forum Programming
    Replies: 3
    Last Post: 08-06-2013, 05:44 PM
  3. Code to determine where a table is in use
    By markjkubicki in forum Programming
    Replies: 2
    Last Post: 07-09-2013, 11:34 AM
  4. Replies: 1
    Last Post: 12-04-2012, 11:46 PM
  5. Opening a form from another with pre-populated data
    By uaguy3005 in forum Programming
    Replies: 4
    Last Post: 07-09-2012, 06:05 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