Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Regular message is taken as an error

Status
Not open for further replies.
seaport

seaport

MIS
Jan 5, 2000
923
US
I have a stored procedure containing the following statement.
exec sp_configure 'Ole Automation Procedures', 1;
RECONFIGURE;

When the above statement runs, SQL server responds with the following regular message, which is not an SQL server error.
"Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install."

My VBA code calls this stored procedure and it has been running fine. A couple months again the Access db started taking this message as Run-Time error. I am sure nothing has been changed on the server. The Access database (VBA code) has not been changed either. I do not know where to look.

Any help is appreciated.
 
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
313
Zyborg
Zyborg
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
3K
Norman Sherlock
Norman Sherlock
Kennelbloke
  • Locked
  • Question
TransferSpreadsheet 3125 Error
Replies
5
Views
1K
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
420
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top