|
-
May 28th, 2003, 01:57 PM
#1
Thread Starter
Frenzied Member
Link Access Databases [Resolved]
How can I link tables from one Access dabase in another Access database through VB on the fly?
Last edited by blindlizard; May 28th, 2003 at 02:42 PM.
-
May 28th, 2003, 02:39 PM
#2
Frenzied Member
The following example utilized early binding (set references to MS Access x.x object type library) or if you have problem with this technique then use late binding instead (CreateObject function)
VB Code:
Dim AccessDB As Access.Application
Set AccessDB = New Access.Application
With AccessDB
.OpenCurrentDatabase App.Path & "\MyDB.mdb"
.DoCmd.TransferDatabase acLink, , "\\server\drive\folder\somedb.mdb", acTable, "Table1", "LinkTable1"
.Quit
End With
Set AccessDB = Nothing
-
May 28th, 2003, 02:41 PM
#3
Thread Starter
Frenzied Member
-
May 28th, 2003, 02:45 PM
#4
Frenzied Member
He, he, he ... Sure am ... :-))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
I drink to make other people more interesting!
Reply With Quote