View Single Post
  #2  
Old April 25th, 2004, 12:13 PM
Marin Kostov
external usenet poster
 
Posts: n/a
Default copy table from closed database

I think this is little strange - the way you are referencing the objects.
My opinion: Use the object model, as written "by the book". What do I mean:
First, open the VBA Editor, and click Tools - References - Microsoft Data
Access Objects 3.60 Object Library. Now you will have all objects defined at
design time, and you will be able to use them and to code efficient.
Next, open the Online help of Access, and then Microsoft Data Access Objects
3.6 (DAO). Check CreateDatabase and CreateTableDef Methods. You can read
OpenDatabase too. There is sample code.
If you do not understand the concepts, you need to read some books about VB
and VBA. There are tutorials in the VBA help systems, in books, MSDN,
Internet...

--
Marin Kostov
Microsoft Office XP Master Instructor