Using UDL possible with DAO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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


Clint said:
I use Access 97 and would like to develop within DAO. A contact mentioned
Click to expand...
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.
 
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
Click to expand...
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 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
Click to expand...
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.
 
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


Clint said:
I use Access 97 and would like to develop within DAO. A contact mentione
Click to expand...
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
 
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
Click to expand...
is Access 97 that my company currently uses. Access 97
does not support COM.
 
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?
Click to expand...
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
Click to expand...
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


Clint said:
Alex,
How much functionality would be sacrificed, if any, by opting for ADO? To
Click to expand...
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
Click to expand...
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?
Click to expand...
Also, I understand its best to create a file for tables only and a separate
file for reports and queries. Is this correct?
 
Back
Top