Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: ODBC Problem with Access 2007

    Thank you all for your quick response

    I will try first to download the SP2 for SQL 2005 as suggested by Mr Wilson and see if it solves the problem because...

  • RE: Run SP from Access 2000 vba

    hi paul,

    try this code

    dim sql as string

        sql = "{call ProcedureName(?)}"

        Set qdf = SQLLink.CreateQueryDef("", sql)

        With qdf

            .Parameters("@Variable") = TxtVariable

            .Execute

            .Close

        End With

    where Procedure name is...

  • RE: Security problem between SQL Server 2000 and Access XP

    Hi Mr Mitchell,

    I tried what you have told me but I got the following error: "Invalid operation." on ".RefreshLink". However, I added to my code the following:

                 .Attributes =...

  • RE: Security problem between SQL Server 2000 and Access XP

    Hi

    First I want to thank you Mr Mitchel for replying to my posted problem.  I think you are right regarding the saving of the password inside the attachement. But,...

Viewing 4 posts - 1 through 4 (of 4 total)