I have the following problem.
My VB app works fine on most computer except this particular one when I get the following error from a particular Sub procedure Automation Error 440.
The procedure takes a username and password from textboxs and passes them to a url on my webserver the returns a record set in the response object as follows.
A shorten version of the procedure is as follows.
Private Sub cmdLogin_Click()
Dim RS As New ADODB.Recordset
Dim VaildLogin As Boolean
Dim SQL As String
dbConn.Execute ("Delete * From tblLastUserAutoLogin")
'First Check User Is Vaild
'Goto Website And Check
" & txtUsername.Text & "&password=" & txtPassword.Text
If RS.EOF = False Then 'This is a vaild User
VaildLogin = True
varWebUserName = txtUsername
varWebPassWord = txtPassword
VaildLogin = False
MsgBox "Login Failed. Please Check Your Username Password Combination."
Set RS = Nothing
My application references Microsoft ActiveX Data Objects 2.1 Library as I want the applicaiton to be compatible with older versions of MS Access. The apps database is current access97 version.
The unusal thing is the computer where the problem occurs has MS Access 2000 installed like most other machines but also this procedure does not use the database but connects to a URL to retrieve a recordset.