Try inserting the string "adExecuteNoRecords+adCmdText" as the third parameterQuote:> I'm connecting to an Access database and sending quite a few insert
> statements at it, and my memory usage is creeping up and up. I'm using ADO
> 2.1 SP2 and Access 2000. I'm creating the connection then command and
> freeing them up afterwards, and if I comment out the code to execute the
> SQL, everything is fine, so I don't think it's my fault. Anybody else seen
> this? Any suggestions?
My enterprise manager has just recently stopped working. I
get the following error message: -2147483647 (not
I tried creating a new snap-in through mmc directly and i
get the following error: 998 (invalid access to memory
I searched the MSN sites for issues and came back with two
1. Access Violation Error Message in Mmc.exe After You
Apply Internet Explorer Privacy Update from Q316116 or
After You Apply Internet Explorer 6 SP1
2. Enterprise Manager May Cause Access Violation When You
Edit a DTS Package with Long User Name
The solution for #1 is to contact Microsoft for the fix.
The solution for #2 is to install the latest sql server
I followed solution #2 with no luck (installed sp3).
Before I pursue solution #1 I'd like to ask this group for
Also, is there a way (thru the registry), to clear all the
SQL groups and registered servers from your enterprise