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 - No Tables Sample Database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

No Tables 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: No Tables Sample Database
    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

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down