Technology and Online Community For All
welcome JOIN US NOW AND FEEL THE DIFFERENCE headbang

Technology and Online Community For All

What You See Is What You Get
 
HomeCalendarGalleryFAQSearchMemberlistUsergroupsRegisterLog in
September 2017
SunMonTueWedThuFriSat
     12
3456789
10111213141516
17181920212223
24252627282930
CalendarCalendar
Latest topics
» Uniblue PowerSuite
Mon Apr 09, 2012 7:27 pm by BlitzKrieG

» Ova Drive Hider
Fri Mar 02, 2012 8:48 am by CodeWarrior

» Ova Folder Security
Mon Feb 27, 2012 5:06 pm by CodeWarrior

» SPSBox
Sun Feb 26, 2012 4:24 am by CodeWarrior

» Norton [all here]
Thu Feb 23, 2012 8:01 am by BlitzKrieG

» OvaSystemSolution CVRS System
Sat Feb 18, 2012 6:06 am by CodeWarrior

» Avril Lavigne - Smile
Sat Jan 28, 2012 7:14 am by ^PiNKHeRMioNe

» Hot N Cold- Katy Perry
Sat Jan 28, 2012 7:11 am by ^PiNKHeRMioNe

» America's next top model (All Stars) Lisa D'Amato
Sat Jan 28, 2012 6:55 am by ^PiNKHeRMioNe

Search
 
 

Display results as :
 
Rechercher Advanced Search
Who is online?
In total there is 1 user online :: 0 Registered, 0 Hidden and 1 Guest

None

Most users ever online was 25 on Fri Dec 19, 2014 9:47 pm
Top posters
trekyboy
 
BlitzKrieG
 
ZNABiRA
 
EDI`STEALTH
 
*B o R g Z
 
SHY
 
CodeWarrior
 
^PiNKHeRMioNe
 
RaiJin
 
chaotic`
 
Similar topics
Statistics
We have 239 registered users
The newest registered user is Hellraiser666

Our users have posted a total of 948 messages in 662 subjects

Share | 
 

 TUT Connect you vb6 to Microsoft Access 2007

View previous topic View next topic Go down 
AuthorMessage
CodeWarrior
Code Master
Code Master


Join date : 2011-12-20
Male Posts : 22

20111228
PostTUT Connect you vb6 to Microsoft Access 2007

Simple tutorial for connecting vb6 to microsoft Access 2007 Database

1. First create database using miscrosoft access 2007 and name it wat you want.

2. In the microsoft Access 2007 Creat table name it wat you want.

3. In the table first field create Name in second field create LastName third field create
MaternalName. then save

4. Open your vb6 create new project and add in the form Label 1 to 3 or Text1 to 3

5. Then open components by pressing Ctrl+T in components list select the
Microsoft ADO Data Control 6.0 (SP6)(OLEDB) then Click Ok
6. Then drag the Adodc to the form

7. In folder or any directory create new TextDocument then rename it any name you want
bat the extension must be .udl sample TextDocument.udl

8. Right Click the Adodc select ADODC Properties then the property page will popup
In General Tab select click the radio button of Use Data Link File then click brows button

9. In Brows Dialog Locate you created TextDocument.udl in the directory click apply

10. The goto RecordSouce Tab In Command Type Select 2-adCmdTable then below the
Table or Stored Procedure Name select your Table name at your Table in Access 2007
then Click OK button

11. In your Labels Properties. In the DataSource select Adodc. And in the DataField Select ta Field of your
created database.

12. Then Run your Program...

Watch this Video
[You must be registered and logged in to see this link.]
Back to top Go down
View user profile

 Similar topics

-
» [ANSWERED] Microsoft Office 2007 Excell Save As PDF is not working
» unable to connect the IWebdriver app to the local network
» Unable to connect to host 127.0.0.1 on port 7055
» could not connect to selenium rc server
» [SOLVED] Can't connect to updates server???
Share this post on: Excite BookmarksDiggRedditDel.icio.usGoogleLiveSlashdotNetscapeTechnoratiStumbleUponNewsvineFurlYahooSmarking

TUT Connect you vb6 to Microsoft Access 2007 :: Comments

No Comment.
 

TUT Connect you vb6 to Microsoft Access 2007

View previous topic View next topic Back to top 

Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Technology and Online Community For All :: Technical Support :: Programming Related :: Visual Basic 6/VB.NET-
Jump to: