Can't Connect to MDB database

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

beic

Beginner

Posts: 21

Monday, February 22nd 2010, 5:23pm

Hi there,

Can somebody help me with this code, I cannot get it to work! :huh:

Source code

Public Sub cmdConnect_Click()

   Dim res As ResultSet
   
   Database1.ConnectMDB("C:\Clients.mdb")
   
   Dim Rows As Integer = 0
   
   JBGrid1.Cols = 3   
   
   JBGrid1.Header(0) = "Name"
   JBGrid1.Header(1) = "Address"
   JBGrid1.Header(2) = "City"
   
   res = Database1.ExecuteStatement("SELECT * FROM Clients")
   
   Do While res.next
 	JBGrid1.TextMatrix(res.getRow() - 1, 0) = res.getString("cName")
 	JBGrid1.TextMatrix(res.getRow() - 1, 1) = res.getString("cAddress")
 	JBGrid1.TextMatrix(res.getRow() - 1, 2) = res.getString("cCity")
 	Rows = Rows + 1
 	JBGrid1.Rows = Rows
   Loop
  
   res.close

End Sub

Always getting some errors...

Best regards,
Viktor

I think it will be a good replacement for VB6 after a little improvements and minor bug fixes... :rolleyes: