Open an ADP as an objet in VBA

[WolvenGarde]

I am trying to open an adp into an object so that I can read a custom
property out of the CurrentProject class of the external file. What I am
working on is a version check routine that verifies the local version of a
file against a master copy in a global network location. I was doing this
using DOA and a custom Database property, but DOA is not compatible with
adp's, and the DB Property layer is not visible in the adp file type.

 

[Sylvain Lafontaine]

There is no local table in an ADP project, so the whole thing of properties
collections has been changed under ADP. I'm not sure to exactly understand
what you are trying to do but maybe the use of the library DSOFile.dll could
help you here:

http://www.microsoft.com/downloads/...c6-520b-4a0a-878a-53ec8300c4c2&DisplayLang=en

Another possibility is the fact that an ADP file is an OLE document like any
other Office document; so probably that you will be capable of adding your
own stream with your own information to the file.

A final possibility would be to simply use Access to remotely access the ADP
file and read its properties collection, either directly using VBA or via
Automation. For more information on how to read the ADP properties
collection from VBA, see:

http://www.eggheadcafe.com/forumarchives/AccessadpSQLServer/Feb2006/post25508758.asp

 

[WolvenGarde]

Sylvain,
Thank you for the post. I was able grab the custome properties with
DSOFile.dll.

Thanks again,
WolvenGarde