Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Foust, Charlotte
  New Posts New Posts RSS Feed - Persisted Recordset Sample Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Persisted Recordset Sample Database

 Post Reply Post Reply
Author
Message
Charlotte Foust View Drop Down
Contributor
Contributor


Joined: 29 Jun 2008
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Charlotte Foust Quote  Post ReplyReply Direct Link To This Post Topic: Persisted Recordset Sample Database
    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: uploads/13/PersistedRST.zip

Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.