I have an access 2000 adp project with an SQL 2000 backend server, I am trying to call a stored procedure with an input and output parameter. My store procedures look like this:

Alter Procedure prcCHK
    (
        @cuid as int,
        @pts as char(10) output
    )
As
select top 1 @pts=pts from tblp1 where custid=@cuid
return

my access procedure look like

   Dim CustomerID As Integer
   Dim pts As String
   CustomerID = 3065
   Set dblocal = CurrentProject.Connection
   dblocal.Execute ("prcCHK" & "'" & CustID & "' , '" & pts & "'")

All I want the code to do is call the stored procedure "prcCHK" and for it to return the a single value 'pts'

I have checked the syntax and it work fine outside of access (SQL Query Analyser) but does not when called from the access code. Any suggestions on how I can get the stored procedure to return a single value to the calling access procedure/function.

I had trouble with that too so I worked around it. I don't remember the order in which I discovered things but the first thing to try (if you haven't already) is add this line to your stored proc:
SET NOCOUNT ON

If that doesn't work, my work-around was to scrap the output parameter and instead have the last line of the proc be a select statement. Then in VBA open a recordset and grab that field.

Example:
In store proc last line is:
SELECT @RetMsg AS RetMsg


In Access:
        strSQL = "EXEC uspMySproc " & _
            Me!ItemVendorNumber

        Set cmd = New ADODB.Command
        With cmd
            .ActiveConnection = CurrentProject.Connection
            .CommandText = strSQL
            .CommandType = adCmdText
            .CommandTimeout = 2400
            Set rst = .Execute
        End With
        Set cmd = Nothing

        strStatus = Nz(rst.Fields("RetMsg"))

This has worked for me every time.