 |  |  |  |  |  |  |  |
Connecting to a access database
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
•
•
Join Date: Mar 2009
Posts: 2
Reputation: 
Solved Threads: 0
Newbie Poster
Dear Sir,
Let me know how to connect a access database in Visual basic 6.
Let me know how to connect a access database in Visual basic 6.
•
•
Join Date: Jul 2008
Posts: 489
Reputation:
Solved Threads: 25
Posting Pro in Training
you can do it very easily. just put a data control. in properties slelect connection type access (if you want to connect office 2000 or next version you need service pack 6). and select the location of file. and then in record source select the table.
I like sword. Attack or Defense.
•
•
Join Date: Mar 2009
Posts: 897
Reputation:
Solved Threads: 167
Practically a Posting Shark
There is another way depending upon what version of VB you have.
Start new standard exe project
Goto vb's ide menu Add-Ins > select add-in manager.
Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK
VB IDE Menu Add-Ins > Data Form Wizard
Run through wizard selecting your access database via browse button on screen 3.
On next form enter the name of the form you want, the style, and the type. I would suggest to start off with the ADO Code unless this is the first time you have ever played with VB.
Actually I would suggest that you use each option with each type and save that as a test project for reference. Then you will have it for reference.
Good Luck
Start new standard exe project
Goto vb's ide menu Add-Ins > select add-in manager.
Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK
VB IDE Menu Add-Ins > Data Form Wizard
Run through wizard selecting your access database via browse button on screen 3.
On next form enter the name of the form you want, the style, and the type. I would suggest to start off with the ADO Code unless this is the first time you have ever played with VB.
Actually I would suggest that you use each option with each type and save that as a test project for reference. Then you will have it for reference.
Good Luck
Nice post vb5prgrmr - wish I had though of that when I started using access with vb6 lol 
As for using Access, Comatose posted a sticky in the VB4/5/6 section about this very subject - http://www.daniweb.com/forums/thread41057.html
I think vb5prgrmr's idea would be easier if you're unsure what you're doing though!
As for using Access, Comatose posted a sticky in the VB4/5/6 section about this very subject - http://www.daniweb.com/forums/thread41057.html
I think vb5prgrmr's idea would be easier if you're unsure what you're doing though!
|
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: List box- Back Colour
- Next Thread: vb6 to export outlook mails to pst
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
