Stored procedure naming in ADP

Discussion in 'Microsoft Access ADP SQL Server' started by Duncan Stott, Jan 12, 2004.

  1. Duncan Stott

    Duncan Stott Guest

    I have an Access 2000 .ADP linked to a SQL2000
    database. Every works fine on my computer but when
    I copy the .ADP to another machine, all of the
    stored procedures show up like
    up_Procedure,1
    which breaks my form code.
    Anyone know why?


    In another forum, a member responded that a Microsoft
    Knowledge Base article addressed this problem. Can anyone
    provide a reference to this article??


    Thanks
     
    Duncan Stott, Jan 12, 2004
    #1
    1. Advertisements

  2. "Duncan Stott" <> schrieb im Newsbeitrag
    news:02de01c3d8f0$d354da50$...
    > I have an Access 2000 .ADP linked to a SQL2000
    > database. Every works fine on my computer but when
    > I copy the .ADP to another machine, all of the
    > stored procedures show up like
    > up_Procedure,1
    > which breaks my form code.
    > Anyone know why?
    >
    >
    > In another forum, a member responded that a Microsoft
    > Knowledge Base article addressed this problem. Can anyone
    > provide a reference to this article??


    I do not know the KB out of my head. But I once had the same problem. Then
    updating the Office Service Pack helped. It had been a well known problem,
    which was addressed in SP2/3 (?).

    Which SP of Microsoft Access are you using?

    Michael G. Schneider
     
    Michael G. Schneider, Jan 12, 2004
    #2
    1. Advertisements

  3. Duncan Stott

    Guest Guest


    >-----Original Message-----
    >"Duncan Stott" <>

    schrieb im Newsbeitrag
    >news:02de01c3d8f0$d354da50$...
    >> I have an Access 2000 .ADP linked to a SQL2000
    >> database. Every works fine on my computer but when
    >> I copy the .ADP to another machine, all of the
    >> stored procedures show up like
    >> up_Procedure,1
    >> which breaks my form code.
    >> Anyone know why?
    >>
    >>
    >> In another forum, a member responded that a Microsoft
    >> Knowledge Base article addressed this problem. Can

    anyone
    >> provide a reference to this article??

    >
    >I do not know the KB out of my head. But I once had the

    same problem. Then
    >updating the Office Service Pack helped. It had been a

    well known problem,
    >which was addressed in SP2/3 (?).
    >
    >Which SP of Microsoft Access are you using?
    >
    >Michael G. Schneider
    >

    Michael

    On another forum, someone came up with this reference

    http://support.microsoft.com/defaul...b;en-us;Q269824


    This addresses the problem

    thanks for the help

    Duncan
    >
    >.
    >
     
    Guest, Jan 13, 2004
    #3
  4. Duncan Stott

    Jerry Boone Guest

    Jerry Boone, Jan 13, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mouse

    Date format for ADP stored procedure

    Mouse, Dec 8, 2003, in forum: Microsoft Access ADP SQL Server
    Replies:
    1
    Views:
    278
    Karen Vaudreuil
    Dec 9, 2003
  2. Paul

    Stored procedure size when bound to an Access ADP report object

    Paul, Mar 2, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    2
    Views:
    198
    Guest
    Mar 2, 2004
  3. Rick Phillips

    Form / List Box Stored Procedure Problem (Detailed) ADP

    Rick Phillips, Mar 5, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    1
    Views:
    247
    Rick Phillips
    Mar 5, 2004
  4. Martin Newman

    Temporary Stored Procedure & adp's

    Martin Newman, Mar 31, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    5
    Views:
    442
    Martin Newman
    Apr 3, 2004
  5. EManning

    Stored procedure/adp question

    EManning, Jul 8, 2004, in forum: Microsoft Access ADP SQL Server
    Replies:
    5
    Views:
    209
    Robertq
    Aug 29, 2004
Loading...

Share This Page