Upgrading to SQL Server 2005 Now Sprocs renamed ...;1

[Lauren Quantrell]

I recently upgraded to SQL Server 2005 from SQL Server 2000, and
Access 2007 from 2003. When I run a ADP created in Access 2000 (which
worked fine in Access 2002 and 2003) in Access 2007 everything is
fine, but when I go back and run it in Access 2000, all the sprocs are
renamed: SprocName;1 (with ";1" added to each sproc name) so they are
not recognized in Access 2000.
Is there a workaround to this?
Thanks,
lq

[lyle fairfield]

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q269824

On Aug 9, 9:23*am, Lauren Quantrell <[e-mail]>
wrote:

I recently upgraded to SQL Server 2005 from SQL Server 2000, and
Access 2007 from 2003. When I run a ADP created in Access 2000 (which
worked fine in Access 2002 and 2003) in Access 2007 everything is
fine, but when I go back and run it in Access 2000, all the sprocs are
renamed: SprocName;1 (with ";1" added to each sproc name) so they are
not recognized in Access 2000.
Is there a workaround to this?
Thanks,
lq

[Chris O'C via AccessMonster.com]

If your Access 2000 installation is missing SP1, it's missing the two
subsequent SPs. Make sure those get installed too, or you're going to have
worse problems.

Chris
Microsoft MVP
Lauren Quantrell wrote:

>I recently upgraded to SQL Server 2005 from SQL Server 2000, and
Access 2007 from 2003. When I run a ADP created in Access 2000 (which
worked fine in Access 2002 and 2003) in Access 2007 everything is
fine, but when I go back and run it in Access 2000, all the sprocs are
renamed: SprocName;1 (with ";1" added to each sproc name) so they are
not recognized in Access 2000.
Is there a workaround to this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

[Lauren Quantrell]

On Aug 9, 10:04*am, lyle fairfield <[e-mail]:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q269824

On Aug 9, 9:23*am, Lauren Quantrell <[e-mail]>
wrote:

Thanks. This is a new machine with both Access 2007 and 2000 recently
installed. It's been a long time since I installed a copy of 2K on a
machine and I had forgotten all the Service Packs. Thanks.
lq

>

I recently upgraded to SQL Server 2005 from SQL Server 2000, and
Access 2007 from 2003. When I run a ADP created in Access 2000 (which
worked fine in Access 2002 and 2003) in Access 2007 everything is
fine, but when I go back and run it in Access 2000, all the sprocs are
renamed: SprocName;1 (with ";1" added to each sproc name) so they are
not recognized in Access 2000.
Is there a workaround to this?
Thanks,
lq- Hide quoted text -

- Show quoted text -