run time error 13

[ghobbes98]

I am running a module as as exe and calling it from another vb program. In one of them I am able to use the following code to set the recordset but in the exe it simply will not work and falls down at this point. It says something about a type mismatch however it works in the other program with the exact same values.

Set dbTable = dbDatabase.OpenRecordset("simul", dbOpenTable)

Anybody have any ideas.
I know it is a bit of a vague question but that might be cause I have been sitting here banging my head off the desk trying to figure it out
Thanks
G

 

[chriswallis]

You you referencing the same ADO library in each case?

 

[ghobbes98]

yeah I have made sure that what both reference are the exact same