MS Access

  • Thread starter Thread starter alan beaumont
  • Start date Start date
A

alan beaumont

When linking a table from an Access application, the
dialogue Get External Data, link tables can be used. Do
you have sample VBA code so this can be done under program
control in the application. E.g. Click a button and browse
to link all the tables in a selected database from
the "browse". Please email on (e-mail address removed) if you have a
vba sample.

Your assistance much appreciated

Alan Beaumont
 
Hi Alan,

Within the Microsoft Visual Basic for Application help topic there are
detailed examples as to how to link to external tables programmatically.

Here are some other examples that should help:

http://mvps.org/access/tables/tbl0009.htm
http://mvps.org/access/tables/tbl0012.htm
http://support.microsoft.com/?kbid=209862


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "alan beaumont" <[email protected]>
| Sender: "alan beaumont" <[email protected]>
| Subject: MS Access
| Date: Mon, 7 Jun 2004 03:01:07 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRMdlnklC8outrZSqqflHjR5Y9JMw==
| Newsgroups: microsoft.public.access.externaldata
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.externaldata:51996
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.externaldata
|
| When linking a table from an Access application, the
| dialogue Get External Data, link tables can be used. Do
| you have sample VBA code so this can be done under program
| control in the application. E.g. Click a button and browse
| to link all the tables in a selected database from
| the "browse". Please email on (e-mail address removed) if you have a
| vba sample.
|
| Your assistance much appreciated
|
| Alan Beaumont
|
 
Back
Top