Gustav Brock
Gustav at cactus.dk
Fri Dec 14 10:42:19 CST 2007
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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com