VBA, Need custom document properties from MDB in R/O directory using DAO

Need custom document properties from MDB in R/O directory using DAO

Author	Message
Shaun Merril #1 / 5	Need custom document properties from MDB in R/O directory using DAO NOVELL RIGHTS problem--MVP's, please help... 1. From the File \| Database Properties menu, Custom tab, create a custom property "AppVersion" and set it to "1.2.3". 2. Inside CurrentDB.Containers!Databases.Documents!SummaryInfo, you can read the custom property. 3. Using Access, Word or Excel File Open dialog, you can also view this same property using the Properties view. 4. Put that MDB in a read-only network directory. 5. Within a separate MDB, write DAO code to read this version into a variable. We have a need to set the custom property in an Access 97 MDB called "AppVersion" to the value "1.2.3" . Then, we put this MDB in a Novell Read-only directory . Then, we must be able to read the property from DAO without creating an .LDB file in that same directory (because of rights.) Please help. Shaun Merrill, 5 yrs full-time developer with Access
Sun, 09 Jun 2002 03:00:00 GMT

Dimitri Furma #2 / 5	Need custom document properties from MDB in R/O directory using DAO Shaun, How about opening that database exclusively? In that case, no ldb file is created. <snip> Quote: > We have a need to set the custom property in an Access 97 MDB called > "AppVersion" to the value "1.2.3" . > Then, we put this MDB in a Novell Read-only directory . > Then, we must be able to read the property from DAO without creating an > .LDB file in that same directory (because of rights.) > Please help. > Shaun Merrill, 5 yrs full-time developer with Access
Sun, 09 Jun 2002 03:00:00 GMT

Shaun Merril #3 / 5	Need custom document properties from MDB in R/O directory using DAO Nope. Exclusive doesn't work. As soon as I take away the CREATE trustee rights to the directory, even the File \| Open dialog cannot detect the rights. It says "No document properties are available for this file." When I give them back, I get Title, Author, Modified, Company, Size, and AppVersion. Quote: > Shaun, > How about opening that database exclusively? In that case, no ldb file > is created. > <snip> > > We have a need to set the custom property in an Access 97 MDB called > > "AppVersion" to the value "1.2.3" . > > Then, we put this MDB in a Novell Read-only directory . > > Then, we must be able to read the property from DAO without creating an > > .LDB file in that same directory (because of rights.) > > Please help. > > Shaun Merrill, 5 yrs full-time developer with Access
Mon, 10 Jun 2002 03:00:00 GMT

Dirk Goldga #4 / 5	Need custom document properties from MDB in R/O directory using DAO This is not a very good solution, but if the database is not encrypted and if you can dope out enough about Access's mdb file format, then you can probably open and read the mdb file itself as just a normal file, locate the property, and get its value. I tried it with a test database -- set a custom property, exited the database, and then opened the database file with a hex editor -- and was able to locate the property name and its value by scanning the file. However, I don't actually know anything about the database format, so I couldn't do this reliably. -- Quote: >NOVELL RIGHTS problem--MVP's, please help... >1. From the File \| Database Properties menu, Custom tab, create a custom >property "AppVersion" and set it to "1.2.3". >2. Inside CurrentDB.Containers!Databases.Documents!SummaryInfo, you can read >the custom property. >3. Using Access, Word or Excel File Open dialog, you can also view this same >property using the Properties view. >4. Put that MDB in a read-only network directory. >5. Within a separate MDB, write DAO code to read this version into a >variable. >We have a need to set the custom property in an Access 97 MDB called >"AppVersion" to the value "1.2.3" . >Then, we put this MDB in a Novell Read-only directory . >Then, we must be able to read the property from DAO without creating an >.LDB file in that same directory (because of rights.) >Please help. >Shaun Merrill, 5 yrs full-time developer with Access
Mon, 10 Jun 2002 03:00:00 GMT

Dimitri Furma #5 / 5	Need custom document properties from MDB in R/O directory using DAO Well, we don't know how the dialog gets the info. Maybe it needs to open the db shared... Did you try to actually open it exclusively from code and get the prop? I know that it works for mdb's on CD, so I assume that File Scan and Read rights should be enough to get it. I can test it on our network if you'd like, but only after the holidays... Quote: > Nope. Exclusive doesn't work. As soon as I take away the CREATE trustee > rights to the directory, even the File \| Open dialog cannot detect the > rights. It says "No document properties are available for this file." When > I give them back, I get Title, Author, Modified, Company, Size, and > AppVersion. > > Shaun, > > How about opening that database exclusively? In that case, no ldb file > > is created. > > <snip> > > > We have a need to set the custom property in an Access 97 MDB called > > > "AppVersion" to the value "1.2.3" . > > > Then, we put this MDB in a Novell Read-only directory . > > > Then, we must be able to read the property from DAO without creating > an > > > .LDB file in that same directory (because of rights.) > > > Please help. > > > Shaun Merrill, 5 yrs full-time developer with Access
Mon, 10 Jun 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]