Transferdatabase does not work in ACAD2006

[Anonymous]

In VBA application, MS-Access database is used and manipulated.
It seems that ACAD2006 does not support 'DoCmd.Transferdatabase' for importing a table. This works fine with ACAD2000.

Is there any solution?

[Anonymous]

The DoCmd object is part of the >MS-Access< object model. If you are trying
to use MS-Access from inside an AutoCAD VBA project, then check your
references to make sure the Access library is present. If not, explain in
more detail.
--
John Goodfellow
irtfnm
use john at goodfellowassoc dot com


wrote in message news:4930506@discussion.autodesk.com...
In VBA application, MS-Access database is used and manipulated.
It seems that ACAD2006 does not support 'DoCmd.Transferdatabase' for
importing a table. This works fine with ACAD2000.

Is there any solution?

[Anonymous]

Well, all the references are in place.
In fact,
docmd.opendatabase.... and
docmd.transfertext.... methods do not give any errors.

I get the following error when mApp.DoCmd.TransferDatabase acImport,...... is executed:
Err.Number=2507
Err.Description="The type isn't an installed database type or doesn't support the operation you choose"

The interesting part is the code runs fine with ACAD2000.
This is extremely urgent. The only new element is ACAD2006.

[Anonymous]

Do I need to re-create .dvb file in ACAD2006 ? or the same one that was developed using ACAD2000 would work?

Shreenivas Potnis