fortypoundhead.com

Simple MS Access Database Demo

Posted On 2017-08-16 by VB6Boy
Keywords:
Tags: VB6 Databases 
Views: 73

Download Attachment


This is a very simple program using VB and MSAccess. This code will allow you to Add, Edit, Delete, and Search entries in the database.

The original project file was hosted on another site, but included references to an OCX control that was no longer available. The author had good intentions, and had hosted it on his personal site for a time, but that went away as well.

I've lightly modified the project, removing the need for the "eye candy" OCX file. Further, since it was bugging me during testing, I've added a loop check to limit the number of times DoEvents is called within loops. This has the purpose of VASTLY increasing the speed of record display during searches and refreshes.

All modifications have been documented with the code.

Requirements

Reference to:

  • Microsoft ActiveX Data Objects 2.0 Library

Components:

  • Microsoft ADO Data Control 6.0 (OLEDB)
  • Microsoft Windows Common Controls 6.0


About the Author

VB6Boy has posted a total of 21 articles.

 


Comments On This Post

No comments on this post yet!


Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.


Your IP address is:54.224.50.28

Before you can post, you need to prove you are human. If you log in, this test goes away.




Recent Forum Posts

Advanced search added
dwirch posted on September 23, 2017 at about 13:44 in Site News

Job Spammer: Gaurav Mehta - AgreeYa Solutions
dwirch posted on September 22, 2017 at about 10:35 in Spammers

Job Spammer: Prutha Siri - Javelin Systems
dwirch posted on September 10, 2017 at about 6:15 in Spammers

New security implemented
dwirch posted on September 7, 2017 at about 7:16 in Site News

Malicious IP Checker Companion Tool
dwirch posted on August 12, 2017 at about 20:24 in Site News

Job Spammer: Steve Adams
dwirch posted on August 8, 2017 at about 7:44 in Spammers