Create table by using DAO 
Author Message
 Create table by using DAO


Private Sub cmdCreateDB_Click()
dbName = "D:\Learning\VB\Contacts.mdb"
If (Len(Dir(dbName))) Then
Kill dbName
End If
Set db = DBEngine.Workspaces(0).CreateDatabase(dbName, dbLangGeneral)

Call createContactTable

Call createNotesTable

Call createCallTypeTable

Call createRelationships

Msg ("Database successfully created")

End Sub

The error message told that "Sub or funtion not defined" and the "Call
createContactTable" is highlighted.

Can anyone help? Your help is appreciated.


Wed, 31 Mar 2004 13:23:58 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help on adding data after creating a table using DAO

2. Creating Microsoft Access Tables using DAO

3. Creating dBase tables using ADO or DAO ??

4. Using DAO 3.5 to Make a New Table from an Exisiting Table

5. Create Tables using Table Data

6. Troble with creating CR using VB6 after create tables

7. Setting the caption property of a table created with DAO

8. DAO - Creating tables with VBA in Access

9. DAO and MSAccess - creating flat file from table

10. Using DAO to set field properties in tables.

11. Linking Excel As Tables Using DAO

12. Delete table using DAO


Powered by phpBB® Forum Software