[AccessD] Saving Table to Registry, ini, ect?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Jim,
 Indeed, It's cool to try new things... at least I think so.. :-)

Gustav,
 I liked your response, it made me laugh :-)  I looked at the other
methods and ended up with a 3rd Linked BE. I will see how this goes.
Since this "setting" table is only for cosmetic use, I choose not to
have the FE handle any of the maintenance for it. I just coded against
the missing database.

 So I will see how this goes....

Thanks to everyone who took the time to respond!



Merry Christmas
WBR
Robert





Gustav Brock wrote:
> Hi Jim (and Robert)
> 
> Yes, but Robert is already handling two linked databases so no further complication will follow by attaching a table of settings.
> You can create the database with one line of code if you keep a master copy in the frontend, and you may not even need to link the table permanently if you use queries with the "IN" syntax for the path and database name.
> Further, code for creating a temp database from scratch has been posted several times. We've used that technique for some projects and it works so fast that you can't notice it. Modify the code to not delete the database on exit and you are done.
> 
> /gustav
> 
>>>> Jim.Hale at fleetpride.com 14-12-2007 17:19 >>>
> 
> What you say is true but personally I know  I get in ruts using the same
> techniques. It makes sense to occasionally question them to see if
> anything out there is better even if all one accomplishes is confirming
> that the best practices are already being used. Heck, I started with
> macros once upon a time until the eureka moment I discovered VBA. So I
> think I know where Robert is coming from. 
> 
> Jim Hale
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Friday, December 14, 2007 2:09 AM
> To: accessd at databaseadvisors.com 
> Subject: Re: [AccessD] Saving Table to Registry, ini, ect?
> 
> Hi Robert
> 
> Your choice, of course, but to me it's like crossing the pond to get
> water.
> 
> /gustav
> 
> 
>>>> robert at servicexp.com 13-12-2007 23:29 >>>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Gustav,
>  You know I had originally thought about doing just that, but I really
> didn't want to have the FE maintain yet another back end. The FE already
> maintains 2 very large BE's.
> 
>  I guess I'm looking for a "new and fresh" way to complete this task.:-)
> 
>  As sometimes happens, the "tried and true" way prevails..
> 
> 
> As always, your input is much appreciated..
> 
> WBR
> Robert
> 
> 
> Gustav Brock wrote:
>> Hi Robert
>>
>> Well, why not just use a local and separate mdb - you have all the
> tools to access it (pun intended) right on hand!
>> /gustav
>>
>>>>> robert at servicexp.com 13-12-2007 17:38:23 >>>
>> Yep, know about them, but what would be the easiest and fastest way to
> save / load those settings. I'm not sure writing out and reading in 1K
> (18 fields) would be the fastest way, maybe it is...?
>> This is in a fairly large / complicated FE (36meg .mde) and load time
> for the framework (and all things related) is already a bit to much..
> :-(
>> WBR
>> Robert
> 
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHYxpa72dSYCwH8FQRAotYAKCyGQPx1BQ8sYrTwMIlvEh2LXB49QCgi/wZ
nFeoMtXZ2du2Wl4wpvT+SvA=
=IfNA
-----END PGP SIGNATURE-----