• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

using transferdatabase method in vba to link dbase IV table

How to use DoCmd.Transferdatabase to link DBase IV database (c:\stubase.dbf)?
0
motech
Asked:
motech
1 Solution
 
Rey Obrero (Capricorn1)Commented:
see if this link helps
How to use dBASE data with Access and Jet
http://support.microsoft.com/kb/230125
0
 
nico5038Commented:
Linking to a database in normally done by linking table(s) using ODBC.
Why do you want to use the DoCmd.Transferdatabase statement for this objective ?

Nic;o)
0
 
motechAuthor Commented:
Thank you for replying. I used the following line of code to fix the problem.

DoCmd.TransferDatabase acLink, "DBase IV", FolderPath, acTable, DatabaseNameWithExtension, TableNameInAccess
   
0
 
nico5038Commented:
Hmm, learning something new :-)
I only used this command to create a new database with copied tables and for linking tables I use the TableDef object and the .connect property followed by a .refreshlink method.

Please ask in CS a moderator to close this question as being answered by you.

Success !

Nic;o)
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now