Passing Variables !? *Resolved*
Hi !!
I wan't to connect to an online database...
What i'm doing now is:
VB Code:
strCn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=http://www.Ziptron.dk/main.mdb;" & _
"Persist Security Info=False"
strSQL = "SELECT * FROM Main WHERE Brugernavn='" & txtUser.Text & "' AND Password='" & txtPassword.Text & "'"
Set rsEmployees = New ADODB.Recordset
rsEmployees.Open strSQL, strCn, adOpenDynamic, adLockReadOnly
but that won't work! It just gives me an error saying Invalid File...
how do i connect to an online DB ? do i have to have some special rights or something ??
Cheers !