Connecting to SQL Server DB on web server

[budgetedi]

I'm trying to get Access 2003 to connect to Microsft SQL Server on a
web server.

I can open the linked table without any problem, but whenever I run the
code on my form, it returns this error: Datatyle mismatch in the query
expression.

Heres the Microsfot SQL Server details...

server: mssql.pipeten.com
username: budgete_kingsgate
password: thehub
database: budgete_kingsgate
And heres the code...

'open recordset
Dim CurrentUserCount As Integer
Dim CurrentUser As DAO.Recordset
Set db = CurrentDb
Set CurrentUser = db.OpenRecordset("SELECT * FROM Users " & _
"WHERE Users.Mobile_No='" & Cleanest_Mobile & "' AND
Users.PIN='" & txt_PIN & "'; ")
It's simply putting the content of an SQL query into a recordset.
thats not even hard. so can anyone understand why it isn't working?

Cheers
Phil.

[Mike Preston]

On 2 Apr 2006 01:29:13 -0800, bu*******@googlemail.com wrote:

I'm trying to get Access 2003 to connect to Microsft SQL Server on a
web server.

I can open the linked table without any problem, but whenever I run the
code on my form, it returns this error: Datatyle mismatch in the query
expression.

Heres the Microsfot SQL Server details...

server: mssql.pipeten.com
username: budgete_kingsgate
password: thehub
database: budgete_kingsgate
And heres the code...

'open recordset
Dim CurrentUserCount As Integer
Dim CurrentUser As DAO.Recordset
Set db = CurrentDb
Set CurrentUser = db.OpenRecordset("SELECT * FROM Users " & _
"WHERE Users.Mobile_No='" & Cleanest_Mobile & "' AND
Users.PIN='" & txt_PIN & "'; ")

Try the following:

Set CurrentUser = db.OpenRecordset("SELECT * FROM Users " & _
"WHERE Users.Mobile_No=" & Cleanest_Mobile & " AND & _
Users.PIN='" & txt_PIN & "'; ")

mike