how to view Stored proceedures in Access 2002 SQL7

[BJ Freeman]

Used to be that Access 2002 showed a View and stored procedure windows.
apparently with a upgrade, the Stored procedure window has vanished and the
View is now Query.

is there away for my clients to get the stored procedure window back.

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Access 2002 (and I presume 2003) stored procedures, functions and
views show under the Query tab of the database window.

Perhaps your SPs don't have the correct permissions set for viewing in
the users database window. If you're working in MS SQL Server & have
Enterprise Manager (part of SQL'r install) check the permissions of each
SP you want your users to look at. Do they have Execute checked?

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJ0M+YechKqOuFEgEQIjzACfeNz4TejejyTPX4S2+FLOZRflUEkAn3pw
uRh5UmDkH0vChqkdDCUR0vns
=zqr6
-----END PGP SIGNATURE-----

 

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Access 2002 (and I presume 2003) stored procedures, functions and
views show under the Query tab of the database window.

Perhaps your SPs don't have the correct permissions set for viewing in
the users database window. If you're working in MS SQL Server & have
Enterprise Manager (part of SQL'r install) check the permissions of each
SP you want your users to look at. Do they have Execute checked?

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJ0M+YechKqOuFEgEQIjzACfeNz4TejejyTPX4S2+FLOZRflUEkAn3pw
uRh5UmDkH0vChqkdDCUR0vns
=zqr6
-----END PGP SIGNATURE-----

 

[BJ Freeman]

oopps hit send key to soon
Thanks that was the problem. I don't have 2002 to play with.
it was in the Query tab and works fine.