By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,220 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,220 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Aug 9 '08 #1
Share this Question
Share on Google+
3 Replies


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

On Aug 9, 9:23*am, Lauren Quantrell <laurenquantr...@hotmail.com>
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
Aug 9 '08 #2

P: n/a
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

Aug 9 '08 #3

P: n/a
On Aug 9, 10:04*am, lyle fairfield <lyle.fairfi...@gmail.comwrote:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q269824

On Aug 9, 9:23*am, Lauren Quantrell <laurenquantr...@hotmail.com>
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 -
Aug 9 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.