using transferdatabase method in vba to link dbase IV table

Posted on 2006-11-09
Medium Priority
Last Modified: 2013-11-24
How to use DoCmd.Transferdatabase to link DBase IV database (c:\stubase.dbf)?
Question by:motech
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17908082
see if this link helps
How to use dBASE data with Access and Jet
LVL 54

Expert Comment

ID: 17908112
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 ?


Author Comment

ID: 17921821
Thank you for replying. I used the following line of code to fix the problem.

DoCmd.TransferDatabase acLink, "DBase IV", FolderPath, acTable, DatabaseNameWithExtension, TableNameInAccess
LVL 54

Expert Comment

ID: 17922799
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 !


Accepted Solution

Computer101 earned 0 total points
ID: 18260784
PAQed with points refunded (500)

EE Admin

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question