Error transferring script to other server

Soon I will go bananas....

I have recently transferred an update asp page from my local test environment (System 1) to another environment (System 2), and get this error message:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/user_admin.asp, line 40

Here is the deal:

1. Both systems have the same setup (Access db, etc)
2. On System one, the page works perfectly.
3. All the other files from system 2, which are identical to the ones on System 1, work perfectly.
4. In fact, I use the same code (for user authentification) in ALL my pages on both Systems 1 and System 2. They also work, except for the one script which I recently tranferred.

Anything I might have overlooked? I would really love to solve thiss problem before Christmas, cause it would rui my holidays. Well, not really, but still answer.

Thank you, happy Christmas shopping.

P.s. Would it help if I posted the code? I really do not think it is buggy because I have used it 2000 times so far, but tell me if you need it.