Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stored Procedure Names (Access 2000 (9.0.2720))

    I have some reports that are based on stored procedures. When I try to run the reporst, I receive an error message that the procedure does not exist.

    In Enterprise Manager the procedure is named usp_EntriesByDate, however, the Access window shows the name as usp_EntriesByDate;1 (dbo).

    I can understand the 'dbo' part, but why does Access add the ';1' to the name?

    Is the name difference generating the error?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Stored Procedure Names (Access 2000 (9.0.2720))

    Is this an Access ADP? The stored procedure names should normally be the same. If it's an MDB, you shouldn't even see the stored procs.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stored Procedure Names (Access 2000 (9.0.2720))

    Yes, it is an Access ADP.

    The table and view names are identical to SQL Server.

    Only the procedures have a different name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •