Results 1 to 5 of 5
  1. #1
    webisti is offline The Wisher
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    115

    Convert linked to local tbales via vba

    Hi I do have a DB that has quite many linked tables.


    I want to make a macro or a vba code to convert these tables into local one (so that the queries and the rest won` t have an issue on delay time)
    Is there a way to do it simple?
    Does anyone have any vba code?

    thanks for your help

    Web.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please explain your environment -- what is the application? What is the problem?
    How many users do you have? Tell us about the linked tables.
    There may be options, but you have to tell us enough about the problem/opportunity
    so we understand the issue in detail and in context.

  3. #3
    webisti is offline The Wisher
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    115
    basically there will be many users using the DB.
    it is a db collecting data from txt unconverted files. via the import export specifications I do choose which fields to import and name them.
    Then these tables serve as a source for a lot of queries reports that users can run.
    Being on LAN and linking it to txt files makes it too slow on acting, by coping the linked tables to local ones
    users will not have issues with system sources exceeded error, or with too long time waiting for the query to run.
    Tha`s why I am looking for a way to create this local tables each time a user will run his own reports.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If you import the text files into one or more tables, and set up proper relationships it should be fine.

    If users will be doing updates, you will need to split into BE and multiple FE. Tables in BE.

    How often do the text files get updated? You'll have to update the related Tables to keep everything in sync.

  5. #5
    webisti is offline The Wisher
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    115
    Actually I found an easy way using the possibility of access2007 build in menu:
    DoCmd.SelectObject acTable, "Company",
    True RunCommand acCmdConvertLinkedTableToLocal

    probably I will need to modify it and make it name all the tables that I want to make as local, but actually putting it behind a onclick button it works finely.

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

Similar Threads

  1. Creating a table with local and external data
    By Accessnoooob in forum Access
    Replies: 8
    Last Post: 06-25-2011, 07:36 PM
  2. Pass Through Queries - Local and Network Tables
    By vinfurnier in forum Queries
    Replies: 1
    Last Post: 03-31-2011, 11:18 AM
  3. Convert local time to UTC
    By zapper222 in forum Programming
    Replies: 0
    Last Post: 08-01-2010, 03:01 PM
  4. Replies: 0
    Last Post: 05-14-2010, 08:43 AM
  5. Form fields export to local table
    By lupis in forum Forms
    Replies: 0
    Last Post: 03-23-2010, 02:38 PM

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