Access 2000 stored procedures in Access 2002

E

EmTeeKay

I have an Access 2000 project connected to SQL Server 2000. When opening the
file in Access 2002 the stored procedures disappear and all forms and reports
relying on those stored procs fail. You cannot even see the stored procs in
the database window, although, you can see the tables. How do I correct this?
 
S

Steve Huff

I believe and someone correct me if I'm wrong - but that only works in Access
2002 which is why you are seeing that behavior.

--Steve Huff
 
N

Norman Yuan

SPs stay in SQL Server, regardless what version of Access priject you use to
view/edit them, just like tables.

In Access 2000, the object bar on the left side of database window, list
"View" and "Stored Procedure" seperately, while in Access2002(XP), They
(Views and SPs) are all under "Queries".

So, as long as your Access Project is connected to a database on SQL Server
properly, you should be able to see "View"s and "Stored Procedure"s by
selecting "Queries" on object bar.

EmTeeKay said:
I have an Access 2000 project connected to SQL Server 2000. When opening the
file in Access 2002 the stored procedures disappear and all forms and reports
relying on those stored procs fail. You cannot even see the stored procs in
the database window, although, you can see the tables. How do I correct
Click to expand...
this?
 
Top