I'M NEW PROGRAMMER ON VB.NET BUT GOO IN VB6
PLS CAN ANYBODY IN THE HOUSE ASSIST ME ON HOW I CAN CONNECT MS ACCESS TO VB.NET

THANK U

Imports System.Data.OleDb

Module Module1

   Sub Main()
       Dim conString As String
       conString = "your connection string"
       Dim oleCon As OleDbConnection
       oleCon = New OleDbConnection(conString)
       oleCon.Open()
       If ConnectionState.Open = oleCon.State Then
           Console.WriteLine("Connected!"
       End If
       Console.ReadLine()
   End Sub

End Module

to get your connection string
open notepad,
save the empty notepad with filename.udl
go to where you saved it double click to open it,
click on the provider tab
Select Microsoft jet 4.0 oleDB provider as your provider
click next
click the browse button to select your database
test you connection by clicking test connection
click OK if the connection succeed. If not that should error on your side

go to where you save your thingy ( i mean the filename.udl)
right click to open with notepad
your connection string is there and you are good to go.


[b]NOTE[/b]The code was writing as console application.
You can also test it there and try to use it on pages.

Call for more 08060678106, 08052451877

Thanks Big Star, I will try it

any progress?

Bigstar

I try it but still give some error, the code are my going to code all under save command?

NO You click on file menu then New Project . Under template, select Console Application.
Copy and paste the code and replace the connection string with your own.
NB Make sure you select Visual Basic as your language

You need to learn to google for solutions. And not just google but READ the solutions to better understand and know how to apply them. Try accessing the database the same way you used to in VB. If the problem is that you are unable to connect, then try troubleshooting from the other end by making sure you connection string is correct and you have permissions and every other variable dealt with.