ACCESS FEED: Re: [MS_AccessPros] Persistence Framework

Rabu, 19 Oktober 2011

Re: [MS_AccessPros] Persistence Framework

Duane - What a clever idea! Thanks for sharing.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 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@...
> 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]
>