No Tables Sample Database |
Post Reply |
Author | |
Charlotte Foust
Contributor Joined: 29 Jun 2008 Status: Offline Points: 4 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 5:28am |
This sample demonstrates remote connections, disconnected recordsets and unbound forms for data entry/edit.
NoTables.mdb is a database with no local or linked tables in the front end. It uses ADO to open recordsets on the back end and then uses those recordsets to populate a form. The recordset is disconnected after being opened and is only reconnected when it is necessary to update the back end table with changes made on the form. The method will work equally well on non-Jet back ends by changing the provider string in the connection object. The database, NoTables.mdb and its back end, NoTablesData.mdb must be in the same directory for the code to work. Download Access 2000: uploads/13/Notables.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |