By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,101 Members | 1,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,101 IT Pros & Developers. It's quick & easy.

stored procedures

P: n/a
Hi, can someone tell me where I should be able to find the code for a
stored procedure on Access?

I have the following statement within one of the queries but can not
find "spAAGetCertNotional" in any of the modules or macros.

exec spAAGetCertNotional

May 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 15 May 2007 06:04:17 -0700, colmkav <co******@yahoo.co.ukwrote:

Typically they are not found in Access, but in the SQL Server database
it is connecting to. Inspect the code around this statement. What
connection string is used?

-Tom.

>Hi, can someone tell me where I should be able to find the code for a
stored procedure on Access?

I have the following statement within one of the queries but can not
find "spAAGetCertNotional" in any of the modules or macros.

exec spAAGetCertNotional
May 15 '07 #2

P: n/a
right I see. The following is the connection string so I suppose the
store procedure is in dbLondon.
ODBC;DSN=GBAG-00025vS2;UID=riskctrl;PWD=password;DATABASE=dbLond on;
On 15 May, 15:56, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On 15 May 2007 06:04:17 -0700, colmkav <colmj...@yahoo.co.ukwrote:

Typically they are not found in Access, but in the SQL Server database
it is connecting to. Inspect the code around this statement. What
connection string is used?

-Tom.
Hi, can someone tell me where I should be able to find the code for a
stored procedure on Access?
I have the following statement within one of the queries but can not
find "spAAGetCertNotional" in any of the modules or macros.
exec spAAGetCertNotional- Hide quoted text -

- Show quoted text -

May 15 '07 #3

P: n/a
On 15 May 2007 07:03:09 -0700, colmkav <co******@yahoo.co.ukwrote:

Correct. And the DSN can be found in the ODBC applet (Control Panel >
Administrative Tools).

-Tom.

>right I see. The following is the connection string so I suppose the
store procedure is in dbLondon.
ODBC;DSN=GBAG-00025vS2;UID=riskctrl;PWD=password;DATABASE=dbLond on;
On 15 May, 15:56, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On 15 May 2007 06:04:17 -0700, colmkav <colmj...@yahoo.co.ukwrote:

Typically they are not found in Access, but in the SQL Server database
it is connecting to. Inspect the code around this statement. What
connection string is used?

-Tom.
>Hi, can someone tell me where I should be able to find the code for a
stored procedure on Access?
>I have the following statement within one of the queries but can not
find "spAAGetCertNotional" in any of the modules or macros.
>exec spAAGetCertNotional- Hide quoted text -

- Show quoted text -
May 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.