Mangled Stored Procedure names ";1"

[Thom]

Thanks in anticipation...
I have an .adp where I connect to an MSDE sql backend. A number of networked PC's connect to this MSDE datasource. All PC's can see and connect to the sql service. However, when I open the .adp, a number of the computers rename all the stored procedures (Office 2000) with an ";1" suffix thereby rendering the file useless i.e. Storedproc;1
I am at my wits end (and client also) to find the cause of this anomaly.
Any help ????

Regards
Thom

 

[cmmrfrds]

Please do not cross post since people answering the post do not know how the issue was finally resolved, or at least reference the other thread in the cross post.

cross post thread181-754761

 

[Thom]

Thanks cmmrfds,
The cross post was not intended to confuse - I didn't realise there was a dedicated .adp forum until I commenced it in Access Other Topics. Sorry for the protocol breach.

I have discovered that you must load/ensure that all the machines using the 'client' (Access adp ) have Microsoft Office Service Release 1/1a applied (for Access 2000). Older releases of Access were released before SQL Server 2000 and hence incompatible.
Microsoft mention that even though SP3 has been applied, it needs to have 1/1a installed.
For additional reference....

http://support.microsoft.com/default.aspx?scid=kb;EN-US;326585

Hope this will help others in dire straights.
Again, many thanks - Thom

 

[cmmrfrds]

Yeah, I ran into that in my 1st adp application about 4 years ago.