The source code in this issue is designed for Visual Basic 5.0 and higher. With some modifications to the parameters it can be used in VB 3 and 4.
This issue shows how to attach an external table to an Access database. This is useful for situations where you need to access tables in other Access databases or other database formats. We will show an example of how to attach a dBASE III type table. Doing the attachment allows you to access data using a query across multiple databases and database types.
Function AttachTable(DestDB As String, SrcDB As String, sTable As String, Optional sDBType as String) As Integer
None unless an error occurs. If an error occurs it will be raised to the caller. Some situations that this subroutine will fail are:
The below example uses the AttachTable to attach an Access table and a dBASE table. It is assumed that the dBASE tables are located in the directory C:\DATA
On Error Resume Next ' Attach the OLDSALES.DBF table in the C:\DATA directory to C:\DATA\SALES.MDB AttachTable "C:\DATA\SALES.MDB", "C:\DATA", "OLDSALES", "dBASE III" If Err <> 0 Then MsgBox "Error: " & Err.Description End If ' Attach the Invoices table to REPORT.MDB from SALES.MDB AttachTable "C:\DATA\REPORT.MDB", "C:\DATA\SALES.MDB", "Invoices" If Err <> 0 Then MsgBox "Error: " & Err.Description End If ' Attach the Customer table to REPORT.MDB from SALES.MDB AttachTable "C:\DATA\REPORT.MDB", "C:\DATA\SALES.MDB", "Customers" If Err <> 0 Then MsgBox "Error: " & Err.Description End If
To see the source code for this issue you must be a subscriber to Code of the Week. If you are a subscriber the source code is available at the following address: http://www.codeoftheweek.com/membersonly/bi/0020.html
That concludes this issue of COTW. We hope you find the source code useful in your development.
The below describes the ways you can supply us some feedback about COTW. We would like to see our members help mold COTW into the best Visual Basic source code resource available. But to do that we need your feedback about what you like and what you do not like about COTW.
We are currently planning for the next several issues of Code of the Week. If you have any suggestions of source code that you would like to see covered, please jump
If you have any suggestions for topics you would like to see covered or questions about this issue, please email them to firstname.lastname@example.org or use online feedback form at http://www.codeoftheweek.com/feedback.html.
If you have any source code you would like to submit for possible inclusion in COTW, please fill out our online submission form at http://www.codeoftheweek.com/submission.html.
Thank you for trying Code of the Week for Visual Basic.
Your free trial expires after you receive your fourth issue. If you want to continue to receive Code of the Week you can get 52 issues of COTW for only $19.95. This is a full year of Visual Basic source code and information to help with all your development. So don't wait, subscribe now! The quickest way to subscribe is to jump to our online order form at http://www.codeoftheweek.com/order.html