i use access 2000 to connect to a remote sql server 2000 database!

all works fine, i can connect, add tables

but

with stored procedures i run in trouble

i use a stored procedure that was written for sql server 6.5

here is the code

***********************

/************************************************************************

*********

*  Table : sp_loginuser_ameel                                            

              *

*  Desc  : Logs in a Valid User into system                              

        *

*************************************************************************

********/

CREATE PROCEDURE sp_loginuser_ameel

(

	@CoyID			VARCHAR(20),

	@UserID			VARCHAR(20),

	@Password		VARCHAR(20),

	@SessionID		VARCHAR(40)

)

AS

	DECLARE @CoyStatus	TINYINT

	DECLARE @Verify		VARCHAR(20)

=09

	IF EXISTS (SELECT SessionID FROM USERLOG WHERE SessionID=3D@S...)

    	BEGIN

      		SELECT Progress=3D1,Errormsg=3D"Session Already Exists."

      		RETURN

    	END



	IF NOT EXISTS (SELECT * FROM COMPANY WHERE CoyID=3D@C...)

		BEGIN

			SELECT Progress=3D1,Errormsg=3D"Company Does Not Exist."

			RETURN

		END



	SELECT @CoyStatus=3DStatus FROM COMPANY WHERE CoyID=3D@C...

	IF (@CoyStatus =3D 0)

		BEGIN

			SELECT Progress=3D1,Errormsg=3D"Company In Disabled Mode."

			RETURN

		END



	IF @UserID =3D "MASTER"

		BEGIN

			SELECT @Verify=3DPassword FROM COMPANY WHERE CoyID=3D@C...

			IF (@Verify=3D@P...)

				BEGIN

					INSERT INTO USERLOG 

(SessionID,CoyID,UserID,AccessNumber,UserState,Createdt,Accessdt) VALUES 

(@SessionID,@CoyID,@UserID,1,0,GETDATE(),GETDATE())

					SELECT Progress=3D0

					RETURN

				END

			SELECT Progress=3D1,Errormsg=3D"Wrong Password."

			RETURN

		END



	IF NOT EXISTS (SELECT * FROM USERS WHERE CoyID=3D@C... AND 

UserID=3D@U...)

		BEGIN

			SELECT Progress=3D1,Errormsg=3D"Unknown User."

			RETURN

		END

	SELECT @Verify=3DPassword FROM USERS WHERE CoyID=3D@C... AND 

UserID=3D@U...

	IF (@Verify=3D@P...)

		BEGIN

			INSERT INTO USERLOG 

(SessionID,CoyID,UserID,AccessNumber,UserState,Createdt,Accessdt) VALUES 

(@SessionID,@CoyID,@UserID,1,0,GETDATE(),GETDATE())

			SELECT Progress=3D0

			RETURN

		END

	SELECT Progress=3D1,Errormsg=3D"Wrong Password."

	RETURN

GO



GRANT  EXECUTE  ON sp_loginuser_ameel TO PUBLIC

****************************

if i want to save this stored procedure in access 2000 i get the 

following errors

ado error invalid column name " session already exists"

nvalid column name " Company Does not exist"

etc.. for all the errormessages i have defined before...

what can be wrong..is a stored procedure to be defined otherwise in 

access 2000 than in sql server?

suggestions?

thanks i really need a solution!



Met Vriendelijke groet,

Eric Van Camp

Atmilestone BVBA

Trolieberg 74

3010 Kessel-lo

Tel:016/35.69.99

Fax:016/35.57.90

eric@a... <mailto:eric@a...>





 <http://www.atmilestone.be/>