Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by JamesDeckert View Post
    ...
    BTW. I had system tables displayed in my original db. So when I imported all tables originally, the system tables were displayed to be imported.


    But if you hide system tables, they aren't displayed when doing import.
    The way I understand it, they are imported or they are integrated with existing system tables, regardless of showing or hiding system tables. Having said that, I think, I believe, if you use VBA to hide the system tables, you will not be able to import them. I did some testing before and I think this was one of the results of my testing.

    The way I understand it, some features that are imported rely on System Tables. So I would have to assume it is possible the Import Wizard may import information from the System Tables. The exception may be if you hide the System Tables using VBA.

  2. #17
    JamesDeckert is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    Well, I narrowed it down to 4 tables. I can import everything and import these 4 tables last and the autoexec works with a missing BE.
    So I don't know which table is/was the problem. But when they are imported last, the db works.
    I just created a new db, imported everything but the 4 tables and it worked. Then imported all 4 remaining tables and it still worked.

    thanks for your feedback ItsMe.

  3. #18
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I am really glad you were able to narrow it down. I know it is not a fun process.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Front End / Back End Question
    By FormerJarHead in forum Access
    Replies: 4
    Last Post: 01-27-2015, 09:10 AM
  2. Form doesn't load when on server
    By missypooh1969 in forum Forms
    Replies: 7
    Last Post: 09-03-2014, 02:03 PM
  3. Front End vs. Back End
    By athyeh in forum Access
    Replies: 2
    Last Post: 07-08-2013, 01:28 PM
  4. Replies: 5
    Last Post: 05-27-2013, 09:34 AM
  5. Load a Linked table into front end when switchboard starts
    By smeghead67 in forum Import/Export Data
    Replies: 5
    Last Post: 02-08-2013, 03:32 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