Access 2000 - Edit SQL Stored Procedures

[RDee]

I am using Access 2000 Project to design a database running on a remote,
shared, SQL Server 2000. I can design Tables with no problem. When I try to
edit(design) any stored procedures, I get error message "ADO error: Could not
find stored procedure 'dt_getproctdef'.

Searching in knowledge base comes up with no hits.

When I open a project on different machine running Access 2003, I can edit
the same database stored procedures without a problem.

Is there some component of Access 2000 that I am missing?

 

[Kevin3NF]

I don't know if you are missing anything, but my best ADP developer refuses
to work on Access 2000 due to the bugs. He makes me sell upgrades to any
client running Access 2000.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Vadim Rapp]

Hello RDee,
You wrote in conference microsoft.public.access.adp.sqlserver on Tue, 14
Jun 2005 13:01:01 -0700:

R> I am using Access 2000 Project to design a database running on a remote,
R> shared, SQL Server 2000. I can design Tables with no problem. When I
R> try to edit(design) any stored procedures, I get error message "ADO error:
R> Could not find stored procedure 'dt_getproctdef'.

I see this procedure in my production database, but not in master. Whicnh
makes me think that it's created by Access Upsize Wizard. Try to upsize some
sample database, then most likely you will find dt_getproctdef in the
resulting database.


Vadim

 

[Razvan Socol]

I hope you know about the following KB Articles:
http://support.microsoft.com/kb/269824
http://support.microsoft.com/kb/266277

Razvan

 

[aaron.kempf]

i fully agree; Access 2000 ADP is _WORTHLESS_

i've gotten dozens of error messages similiar to that one tho-- even
with 2002 and 2003.. i used to work at MS but then i got fired for
bitching about Access

so uh.. good luck they dont take ADP seriously

i love ADP personally.

I just know that Microsoft isn't takign ADP seriously. And I call for
Microsoft to WAKE UP and start taking it seriously.

 

[RDee]

Thanks for your assistance.

I used the procedure in kb269824 to copy client tool files onto the box
running Access 2000. Now editing stored procedures works as expected.

RDee.