Using UDL possible with DAO

[Clint]

I use Access 97 and would like to develop within DAO. A contact mentioned using UDL in a routine which I wish to adopt and connect to AutoCAD. This would be used to pass data from MS Access to populate flelds in a cad file. Again, I am limited by MS Office 97 era technology

Can I use UDL with DAO?

 

[Alex Dybenko]

no, you can use it only with ADO. but you can also use ADO in access 97, not
100% like in later versions, but still you can open recordsets, copy data

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

I use Access 97 and would like to develop within DAO. A contact mentioned

using UDL in a routine which I wish to adopt and connect to AutoCAD. This
would be used to pass data from MS Access to populate flelds in a cad file.
Again, I am limited by MS Office 97 era technology.

 

[Chris Nebinger]

What is a UDL? I've heard of a UDF (Fser Defined Function)

What version of AutoCAD? The newer ones support VBA and
COM. Set a reference to AutoCAD (Tools, References), and
then you can manipulate AutoCAD that way.


Chris Nebinger

-----Original Message-----
I use Access 97 and would like to develop within DAO. A

contact mentioned using UDL in a routine which I wish to
adopt and connect to AutoCAD. This would be used to pass
data from MS Access to populate flelds in a cad file.
Again, I am limited by MS Office 97 era technology.

 

[Clint]

Chris N.,
I have the latest version of AutoCAD. The limiting factor is Access 97 that my company currently uses. Access 97 does not support COM.
As far as UDL; search this MS site and you will find much about it.

----- Chris Nebinger wrote: -----

What is a UDL? I've heard of a UDF (Fser Defined Function)

What version of AutoCAD? The newer ones support VBA and
COM. Set a reference to AutoCAD (Tools, References), and
then you can manipulate AutoCAD that way.


Chris Nebinger

-----Original Message-----
I use Access 97 and would like to develop within DAO. A

contact mentioned using UDL in a routine which I wish to
adopt and connect to AutoCAD. This would be used to pass
data from MS Access to populate flelds in a cad file.
Again, I am limited by MS Office 97 era technology.

 

[Clint]

Alex
How much functionality would be sacrificed, if any, by opting for ADO? To the best of your knowledge, are there major limitations in linking/transferring data between AutoCAD and A97.
My goal is to develop a routine in VBA which can roundtrip data between the two apps,the database and the cad app, mentioned above for assigning cad file identification numbers and revisions on a relatively small scale (100-300 cad files/yr.

For security, would it be best to create a MDE extension database file? Also, I understand its best to create a file for tables only and a separate file for reports and queries. Is this correct?
Are these the only methods in designing a database that is both secure and fast? What are some others

----- Alex Dybenko wrote: ----

no, you can use it only with ADO. but you can also use ADO in access 97, no
100% like in later versions, but still you can open recordsets, copy dat

--
Alex Dybenko (MVP
http://Alex.Dybenko.co
http://www.PointLtd.co

I use Access 97 and would like to develop within DAO. A contact mentione

using UDL in a routine which I wish to adopt and connect to AutoCAD. Thi
would be used to pass data from MS Access to populate flelds in a cad file
Again, I am limited by MS Office 97 era technology

 

[Chris Nebinger]

Oh, the .udl file. I got it now.

And I could have sworn that I've used COM to AutoCAD from
A97. I know I have to ArcMap/ArcInfo. Can you go to
tools/references and add a reference to AutoCAD?

Chris Nebinger

-----Original Message-----
Chris N.,
I have the latest version of AutoCAD. The limiting factor

is Access 97 that my company currently uses. Access 97
does not support COM.

 

[Alex Dybenko]

if you have to use ADO and Access 97 - then you can make a procedure with
load/save data from autocad to access table using ado - and then make all
other things in access 97 using it native libraries

For security, would it be best to create a MDE extension database file?

Also, I understand its best to create a file for tables only and a separate
file for reports and queries. Is this correct?

Are these the only methods in designing a database that is both secure and

fast? What are some others?

yes, this is correct. but also depends on what exactly this application
should do

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Alex,
How much functionality would be sacrificed, if any, by opting for ADO? To

the best of your knowledge, are there major limitations in
linking/transferring data between AutoCAD and A97.

My goal is to develop a routine in VBA which can roundtrip data between

the two apps,the database and the cad app, mentioned above for assigning cad
file identification numbers and revisions on a relatively small scale
(100-300 cad files/yr.)

For security, would it be best to create a MDE extension database file?

Also, I understand its best to create a file for tables only and a separate
file for reports and queries. Is this correct?