Ask your question
Message list Discussion Forum list

VB connection with ms access

Kisa - Nov 9, 2009 10:11am GMT - Last answer on Nov 9, 2009 8:27pm GMT bytelogik
Report
Hello,I have a problem with connection of vb using ms access 2003 and 2007.Can you help me to give the help of its code of connection
ThanksConfiguration: Windows XP Internet Explorer 6.0
Read more ...

Plus de résultats pour :
VB connection with ms access»

I have an answer
Add comment

Kioskea recommends you to read :

CONNECTION VB 6 WITH MS ACCESSForumProgramming
Connecting vb to database [Solved]ForumSoftware
How to make database connectivity in asp.netForumProgramming
How to connect VB6 to MS Access 07ForumProgramming
Pls help......VB 2008 + Microsoft Access 2007ForumProgramming
Ms access not connect with vb.net give errorForumProgramming
Sort by :   Votes | Date | Date descending 1 answers
Best answer
+1
moins plus
bytelogik 10Posts October 5, 2009Registration date Nov 9, 2009 8:27pm GMT
Add DAO 3.6 Reference to your project

Dim dbDef As Database
Dim rsDef As Recordset
Set dbDef = DBEngine.OpenDatabase(YourDatabasePath", False, False) 'ex: your databasepath = "c:\something.mdb"
Set rsDef = dbDef.OpenRecordset("select * from yourtable") 'ex: yourtable name of table in the database you want to access
do while not rsDef.EOF
'read records
rsDef.MoveNext
loop
Set rsDef = Nothing
Set dbDef = Nothing

 Add comment - Permalink (1)
Add comment
Top
See also
supinfo