topic Transferdatabase does not work in ACAD2006 in VBA Forum

Transferdatabase does not work in ACAD2006

Anonymous — Wed, 17 Aug 2005 02:46:54 GMT

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?

Re: Transferdatabase does not work in ACAD2006

Anonymous — Wed, 17 Aug 2005 12:39:00 GMT

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?

Re: Transferdatabase does not work in ACAD2006

Anonymous — Wed, 31 Aug 2005 10:59:43 GMT

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.

Re: Transferdatabase does not work in ACAD2006

Anonymous — Wed, 31 Aug 2005 11:25:51 GMT

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

Shreenivas Potnis