RE: [MS_AccessPros] Persistence Framework

Mark(?),
"application's important settings" have you considered running the database documenter? The results of the documenter are saved temporarily in a table in a wizard database in your profile. I'm using Access 2007 at the moment so my table is doc_tblObjects in C:\Users\ushookomd\AppData\Roaming\Microsoft\Access\ACWZUSR12.ACCDU.

In the past, I have run the documenter with all of my "application's important settings" and then imported the doc_tblObjects table into my application file or another file. The table has only a few fields and is quite normalized so you have to play with it to make it useful.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: marksimms@verizon.net
Date: Wed, 19 Oct 2011 10:42:15 +0000
Subject: [MS_AccessPros] Persistence Framework

I'm about to embark on a mini-project to create a set of functions and tables that will store any application's important settings. The settings could be at the following levels: application (title, color theme, etc), object (default form settings, report settings, etc, object and user (the key of a form's last record viewed, user default value preferences, etc), and finally user-level (initial form to open upon start-up, etc).
Has anyone attempted this before ? I built a similar framework using SaveSettings, GetSettings but I was unhappy with that result for several reasons: it was registry-based, the settings couldn't be easily cloned or transferred, etc.
Database properties is another option, but I think it is way too unwieldy for the flexibility of storing and retrieving these settings at all of the various levels as outlined above.
Comments/suggestions greatly appreciated.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/