Many thanks. Will follow your advice.

BTW, the code was pinched from Auto2000.chm
(a file extracted from Auto2000.exe) which is
MS Technical Support's guide to Automation in
Office2000.

Regards and thanks.

"Marin Kostov" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004