Re: How to store Misc. Info within a database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



"=?Utf-8?B?U3JNb3Vzc2U=?=" <SrMousse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:E8618570-2013-4DF4-9F8D-0A4BD471961C@xxxxxxxxxxxxx:

>
> However, I now have a bunch of other misc. data that I need to store,
> like the "Working Year" (I am going to use the field to dictate which
> year of info to pull the data from) "Common Header", etc.
> Additionally, I am considering storing formatting data such as font
> size (still considering this).
>
>

I use the database properties for these, because for me they're attributes
of the application rather than core data.

If they need to be invisible, use the DAO.Database.Properties collection.

If you want them to be user-accessible, use DAO.Database.Containers
("Databases").Documents("UserDefined").Properties because these are the
ones that appear on the File | Properties dialog. (I think -- you need to
check the help files for the exact access path.

Hope that helps


Tim F
.



Relevant Pages

  • Re: OT Dim Edwards goes to Wal Mart for his new toy!
    ... Grabbed a bunch of other items we ... a grocery store and drug store. ... They must of had 30 different small food choppers in a variety of colors. ... bought one in white and was out the door in a few minutes. ...
    (alt.autos.toyota)
  • Re: in praise of SmokingPipes.com
    ... They are a great bunch. ... By far the biggest tobacco shop I ... have ever been in with tons of pipes and tobacco. ... you should visit the store. ...
    (alt.smokers.pipes)
  • Re: How to store Misc. Info within a database
    ... This does mean that I have to store all option values as text, ... > Some of the data is a "Common Footer" that prints on ALL reports and DOES ... I now have a bunch of other misc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: bump... bestbuy Japan fujis
    ... finding the CD-R shelves utterly bereft of product, ... super-super-secret part of the store, and found a bunch of them tucked ...
    (rec.music.gdead)