Ok, I managed to get it working...
vb Code:
  1. mports System.Data.SqlServerCe

  2.  
  3. Public Class Drivers

  4.     'Global Variables

  5.     Dim userName As String

  6.     Dim password As String

  7.  
  8.     Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click

  9.         'save the entered username into a variable

  10.         userName = tbUserName.Text

  11.         'save the entered password into a variable

  12.         password = tbPassword.Text

  13.  
  14.         Dim jitDatabase As New SqlCeConnection("Data Source = My Documents\JIT.sdf")

  15.         jitDatabase.Open()

  16.  
  17.     End Sub

  18. End Class

I've posted another thread about modulating this... Please look at that if you can, thanks to everybody who posted on this one!