Ok, you can simply use automation, like this:
Dim acs as Access.Application
Set acs=New Access.Application
acs.OpenAccessProject("C:\.....\MyADP.adp")
acs.DoCmd.OpenForm "......"
....
"Tony Burba" wrote in message
news:5423289@discussion.autodesk.com...
Thanks all.
I go to SQL directly whenever possible, but what I need to do is activate
some Access forms that are in the Access front end, not the SQL database.
Anyway, I think I figured out how to create the connection I need.
"Norman Yuan" wrote in message
news:5421785@discussion.autodesk.com...
You do not connect AutoCAD to ADP by using *.udl/Data Link Properties dialog
box.
ADP is merely a front end desktop application (as AutoCAD) and it does not
contain data. All data is in the backend SQL Server database.
The better way to manipulate data in SQL Server is directly go to the SQL
Server database from AutoCAD (I am sure you know there are quite a few
ways). If you do want to manipulate data through forms already designed in
ADP application (so you do not have to rewrite/redesign similar forms and
their logics), you can automate Access through ActiveX Automation. However,
I'd avoid this and go directly from AutoCAD to SQL Server database whenever
it is possible.
"Tony Burba" wrote in message
news:5421422@discussion.autodesk.com...
I need to activate forms in a MS Access Project (.adp) file through AutoCad
VBA, but can't figure out how to create the necessary link (.udl) file.
An .adp file is an Access front end to a SQL Server database back end. I had
no problems before I converted the back end to SQL from Access, but before
the conversions both the front and the back were simple Access (.mdb) files,
and the connections were easy.
Anyone know how to do this?
Thanks . . .
