Print Page | Close Window

Persisted Recordset Sample Database

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Foust, Charlotte
Forum Description: Charlotte Foust's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=198
Printed Date: 28 Mar 2024 at 6:22am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Persisted Recordset Sample Database
Posted By: Charlotte Foust
Subject: Persisted Recordset Sample Database
Date Posted: 10 Jul 2008 at 5:26am
 This self-contained sample database demonstrates the use of ADO persisted recordsets in Access 2000. Switchboard choices allow the user to persist a recordset from a pre-built query in either table or XML format, to display and edit that recordset in a form, and to update the underlying table from that recordset. Because forms bound to a Jet provider-based ADO recordset are not normally updateable, I've used an unbound form to permit the user to view and edit the recordset.

Since persisted recordsets are "portable", they can be exchanged between machines and even applications. The only caveat is that to sync the recordset back to a table requires a table with the exact structure the recordset was built on. This works just as well with SQL Server or any other OLE DB compliant database as it does with Access/Jet.

Download Access 2000: http://www.rogersaccesslibrary.com/forum/uploads/13/PersistedRST.zip - uploads/13/PersistedRST.zip




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