Link Tables thru VBA

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Link Tables thru VBA

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

November 19th, 2004, 03:03 PM

Rchanga

Rchanga is offline

Registered User

Join Date: Nov 2004

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Link Tables thru VBA

How do I link AS/400 tables in to access database using VBA code.
Thanks

Old

November 20th, 2004, 11:06 AM

jemacc

jemacc is offline

Friend of Wrox

Join Date: Nov 2003

Posts: 625

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to jemacc

Default

I believe you can use transferdatabase method to do that

DoCmd.TransferDatabase acLink, "Microsoft
Access", "DataImportedFrom.mdb",
acTable, "SourceTableName", "DestTableName"

Look up transfersdatabase method to get more details

Jaime E. Maccou
Applications Analyst

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting data from link tables	psnow1985	SQL Server ASP	0	March 27th, 2008 03:19 PM
How to link new tables using code to MSAccess	Nordiers	Access VBA	2	January 10th, 2008 11:35 PM
link 2 tables only for application, not for databa	W052107	ASP.NET 2.0 Professional	2	May 29th, 2007 07:41 AM
Link FoxPro tables through OLEDB	catudalg	Access	2	May 8th, 2007 08:16 AM
Link tables from two different SQL Databases	Folorunso Agbeja	SQL Server 2000	1	October 19th, 2006 08:23 AM