Results 1 to 4 of 4
  1. #1
    hammerman is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Posts
    32

    In a split dB, How to add a new table in _be?

    Sorry for not looking first.


    PS> I do enjoy reading the answers to all the other issues. I am gathering knowledge from it. thanks.
    Last edited by hammerman; 05-11-2017 at 12:51 PM. Reason: Problem solved, by Googling. Never Mind!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    you add it manually. You shouldnt need to add tables often. Only for new enhancements.
    add table in BE
    link to FE
    distribute FE to all users.

  3. #3
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,422
    You open the be and the table is there, but doesn't show in the list of tables to link to when you open the fe?
    Then I guess the table is set to be hidden in the be, or you're pointing the fe to the wrong folder
    IT moved the data/files/folders/etc from one server to another
    If others can see it but you cannot, then your fe must be mapped wrong.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    hammerman is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Jul 2014
    Posts
    32
    Ramman256 & Micron: Yes, this is the first time in 2 yrs I'm adding a table; I did add it to _be; I think my mistake was correctly linking to the table in the _be from the _fe. A quick 'google' showed the correct procedure, which I had done 'almost' correctly. when I followed the instructions, it worked. thus "solved".
    No one else sees it because it is brand new. I'm prepping to be able to use it, insert records into it, with a form/recordset/query process I have used from the beginning, for the other tables. The _fe is also on the file share, separated from the _be, and any user needing access to the dB downloads the runtime.exe file and the _fe file, but not the _be. They then run the 'runtime' ! The _fe is written so limited access is granted, preventing corruption of data. (some users have MSAccess, and know the circumventions to bypass that, but not many. No data in dB is dangerous to anyone, its just an asset tracker for engineering r&d materials. So, corruption isn't 'lethal', only frustrating, if it should happen. its therefore an innocuous application.

    thank you gentlemen. I appreciate your attention and rapid responses. You both have a great day!

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

Similar Threads

  1. Split table?
    By FNey in forum Database Design
    Replies: 4
    Last Post: 05-17-2016, 06:22 AM
  2. How to split the table
    By mb1984 in forum Access
    Replies: 1
    Last Post: 05-26-2015, 02:14 AM
  3. Split a table?
    By dlab85 in forum Access
    Replies: 2
    Last Post: 02-06-2013, 11:45 AM
  4. Split a table
    By bobi123 in forum Queries
    Replies: 2
    Last Post: 10-22-2012, 08:24 AM
  5. Replies: 1
    Last Post: 12-01-2010, 11:01 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