Subscript out of range (Error 9)

[Nikos]

I am having this "Subscript out of range (Error 9)" error immediately after starting my application. This is followed by a

MY.EXE caused an invalid page fault in module MSVBVM60.DLL at 0177:660d44b0

So far so good... The problem is, that this error appears olny with some MSWindows configurations and NOT with others on which is working perfeclty!!! Does this make any sense?

I have searched (and found) all the relevant articles about error 9 in MSDN.... Nothing of these is the case here... double-checked that...(by the way, I am suspecting contol panel's regional settings but I am not sure...)

Any ideas would be most helpful..thanks
Nikos

ps. My app uses DAO 3.6 and have been compiled using VB6SP3.

[substring]

Correct me if I am wrong, I thought that is a data access error. Do all these machines have the same DSN or ODBC setup?

By the way, you should upgrade your VB6 to SP4. It is downloadable from MS site.

substring.

[Nikos]

Well, I am using the standard DAO approach:

DBEngine.Workspaces(0).OpenDatabase

ODBC etc setup is for ADO only...isn't it?

[substring]

Sorry, I don't know DAO. There is no reason to use it unless you are using an old version of VB. But since you are using VB6, you should use ADO. It is more powerful.

substring.