Linking tables using VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tim (anonymous_at_discussions.microsoft.com)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 09:06:11 -0700

I am building a database which can be used stand-alone on
a laptop or linked to a central database when connected to
a network.

I have written code to enable the user to establish a link
when required, as follows:

DoCmd.TransferDatabase acLink, "Microsoft
Access", "D:\Folder\Database.mdb",
acTable, "Logon", "Logon", False

I have also written code to delete the table when the user
needs to log-off the network.

My problem is that I have a number of tables I wish to
link in this way and rather than hard-code the details
separately, I am sure I should be able to record the
relevant details (table names, path etc) in a table and
then have the code loop through, linking each in turn.

Does anyone have any ideas on how I can do this?

Relevant Pages

  • Re: Replication within SQL Express
    ... The trigger is not going to be fired across the network. ... to do is have some action originating on the remote locations move data to ... is moved to the central database if there is a network connection. ...
    (microsoft.public.sqlserver.replication)
  • Re: Access2003
    ... > or if you prefer the network user name: ... rather than allenbrowne at mvps dot org. ... >> All the tables are in a separate and central database on a LINUX server. ...
    (microsoft.public.access.tablesdbdesign)
  • Access2003
    ... Currently we run Access 2003 on several machines on XP pro machines networked ... All the tables are in a separate and central database on a LINUX server. ... Total network at present is 16 machines, ...
    (microsoft.public.access.tablesdbdesign)