Print Page | Close Window

Unbound

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Forbes, Michael
Forum Description: Michael Forbes's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=202
Printed Date: 28 Mar 2024 at 3:43pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Unbound
Posted By: Michael Forbes
Subject: Unbound
Date Posted: 10 Jul 2008 at 5:33am
This VB6 applet connects to a JET database just long enough to load the contents of a table into a listview control in the VB application, then discards the database connection (just the link, not the actual file). Label editing is set to 'manual' in the listview, so to change data, just click on the row you want to edit. The form_unload event creates another new instance of the database connection and then automatically runs through each listitem in the listview, updating the database to match any changes made by the user. It then discards the database connection again. The advantage of doing this is that the database is never opened for more than the time it takes to load the controls on the form; this is as opposed to databound controls, which can have the unfortunate effect of locking the database in a way that prevents modifications by the developer/administrator. 5) VB6 FE/A2K BE

Download VB6 FE/A2K BE: http://www.rogersaccesslibrary.com/forum/uploads/12/Unbound.zip - uploads/12/Unbound.zip



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

Email: mailto:cognos.pax@gmail.com - cognos.pax@gmail.com
No additional terms/restrictions. Distribute freely, copy freely, no need for credit.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net