Michael Maddison
michael at ddisolutions.com.au
Wed Dec 12 19:46:02 CST 2007
How about persisting an ADO recordset to either xml or binary. Then just load it on startup. Either loop through setting properties on load or do a seek when different settings are required. cheers Michael M Howdy Hope I haven't misread the q I usually have a local Settings dB Usually in the same folder or something like C:\Mydb_LocalSettings folder etc This dB's sole purposes is to hold local settings I assume you have FE/BE setup? Yes? If so - I just get the FE to link to 2 external dB's One for the standard back end stuff (The Majority of data) Then I get it to link to a table (or two) in the local settings dB No big deal having your FE link to tables in 2 dB' Infact in my experience - network considerations and maintenance of the linking between 2 x back ends is the biggest PITA See ya hope this helps DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Thursday, 13 December 2007 11:28 AM To: Access Developers discussion and problem solving Subject: [AccessD] Saving Table to Registry, ini, ect? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello All, I have a table (in a large .mde FE), that holds about 18 datasheet property field settings for about 20+ datasheet forms(user options). It all amounts to about 1,000 records. I need to store these settings on the users machine (so when I update the program, I don't override their selected settings), and I'm looking for the easiest / fastest way to save and load this information to / from the FE. The information would be loaded on startup and saved to the users machine on shutdown.. Any examples would be most helpful. Thank You WBR ~Robert -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHYHya72dSYCwH8FQRAoPOAKCshtr1jZ4yz9UWl4d06CMRx4Ci5wCeK1C/ cwxSocadPU3affvdAqplkK4= =SrU3 -----END PGP SIGNATURE----- -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com