ODBC Workspace

[Muttley]

Hi,

I'm trying to open an ODBC workspace in a sub, declaring the workspace as follows:

Dim wrkMain as Workspace

And I get the following error message when I run the code:

"A module is not a valid type"

I am running the sub from a button on a form, have tried running it also as a stand alone module, but still no joy. Removing the 'Option Explicit' declaration stops the problem, but I don't want to do this for other reasons. Can anyone help!!!!!

 

[rpbenito]

Make sure that your ODBC drivers are installed.....if not go to

http://www.technet.oracle.com

and go to downloads...ODBC driver and dl the proper driver...that should work after that

good luck