Have you tested the following?

EXEC proc 1

EXEC proc 2?

Please don't multipost the same question

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=198526

Have you tried cmdx.CommandType = adCmdStoredProc ?

Last company I worked at ENFORCED CASE-SENSITIVITY to INCREASE PROFIT!

They reasoned that the SAME userid coming from the SAME phone number for the SAME client even though spelled...

Without intentionally making this sound stupid...  Have you checked BOL for any of this?

I received the "award" once.  Probably deserved it a couple more times but other people made larger mistakes

Remi,

The "Golden shoehorn" was started by our company to go with the "Golden tractor" that our Network Administrator had.

It literally is a shoehorn spray painted gold that you have...

It could be that, or a timeout, or...., or...

Nicolas,

Believe it or not that is all I have.  A co-worker ran across this and we have implemented same proc with using the input params vs input > internal...

I honestly think it would be easier to put that into a DTS package with VBScript and fire off jobs from there...

My own personal WHOOPS (One of many)

I once wanted to DELETE from tblUSERS WHERE ....  Unfortunately, I had the command on multiple lines and highlighted the DELETE FROM ...

Needless to...

You can move the LDF to a different location then the DB thinks which will force a new log to be created.  It will complain that a new log will...

How many records are typically being DELETEd?  IF Most THEN right the good records to a TEMP table TRUNCATE the REAL table and reload.

Transaction keeps track of everything and allows...

Mat,

There is no alert you can create for that (AFAIK).  You will need to run a job every (n) minutes to see if file exists and IF TRUE THEN...

MSAccess will hold a couple of million rows per table.

The REAL question is HOW large is the database going to be.  Access 97 DB size limit is 1GB, Access 2K...