Stored procedure name ends with ;1

[Barry Ray]

We have just upgraded from Small Business Server 4.5 running SQL Server 7 to
Small Business Server 2003 running SQL Server 2000 and have discovered the
following problem on NT4 workstations running Access 2000 adp applications
connected to the new network:-

Stored Procedure names are listed in the database window with the suffix ;1
(e.g. a sproc with name 'sp_Clients' is listed as 'sp_Clients;1')

This means that none of the forms based on Stored Procedures work and it
doesn't seem possible to view the procedures in design view or even to
design a new one. (All other objects, such as Views, seem to behave as
expected)

The NT4 workstations all have SP6a installed and the adp application was
recompiled and reconnected to the new server before distributing to the
workstations on the network. This problem doesn't occur on any Windows 2000
or XP workstations running the same application and connected on the same
network.

I've tried to search for some information on this in the MS Knowledge Base
but haven't turned anything up yet. If any one can shed some light on this
matter it would be most appreciated!

Thanks

Barry Ray

 

[Jerry Boone]

It's a bug.

You need to apply a service pack for office.

There is a kb article on http://msdn.microsoft.com/support but I can't
remember where it was, just seen it in another post last week.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access

 

[SFAxess]

Here is a link to the article in question.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;266277

 

[Eva Etxebeste]

Hello Barry

This article could be usefull for you http://tinyurl.com/3e6hw

Regards