Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 January 3rd, 2008, 04:48 PM
Registered User
 
Join Date: Nov 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to link new tables using code to MSAccess

Trying to link new tables from a backend database to the front end using a function.

I distribute the database to multiple location with code update. When the location receive it, it needs to link to their localize server.

Any help is welcome

 
Old January 10th, 2008, 03:15 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Search this forum for "table relinker."

Also, there is supposed to be a relinker in Access as an install option (Use the Add-In Manager.) I was unable to find the media.

There are some relinkers on the internet for sale as well.

HTH

mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old January 10th, 2008, 11:35 PM
Registered User
 
Join Date: Jan 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to faridrd
Default

Im not sure what is it you are looking for. But if your problem is how to manually link back tables in a database using a function. then I guess use :

'delete the current table currently on the system
DoCmd.DeleteObject acTable, TargetTable

'create a linked or imported table to the current database
DoCmd.TransferDatabase acLink, "ODBC Database", StrCon, acTable, _
    SourceTable, TargetTable

acLink or acImport depending on the type of table whether a linked or imported table.

StrCon is the ODBC connection String

acTable is the type of object you want to import.






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
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
How do I rename MSAccess tables in C#? veggiemanuk ADO.NET 3 October 22nd, 2005 09:03 AM
Link Tables thru VBA Rchanga Access 1 November 20th, 2004 11:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.