Skyusa11,
That's is what I am talking about. The VB6 (at least the version I have at home where I have worked with the Database connectivity and such) uses a DataEnvironment (which in your instance is called Data1) to connect rather than the OpenDatabase function.
Ah, here we go. Consulting my Help files that are found in my VB6, I find that OpenDatabase corresponds to DAO 3.51. You are now using 3.6. Also found in my help manuals:
------------------------
Obsolete Features in DAO
Microsoft Access versions 1.x and 2.0 and Microsoft Visual Basic version 3.0 used earlier versions of DAO. Several objects, methods, properties, and statements in those earlier versions are considered "obsolete" but are still supported for backwards compatibility with existing user code.
The following is a list of DAO methods, properties, objects, and statements that have been replaced by more powerful, flexible, and easy-to-use features. Each obsolete feature in the list has a corresponding replacement feature.
...
OpenDatabase statement
...
-----------------------------
Therefore, the OpenDatabase may be still implemented in some versions for backwards compatabillity, but that's about it.
So since you are using the DAO 3.6, I'm afraid you are going to have to implement via DataEnvironment objects instead of by OpenDatabase.
Hope that helps a little more.
-crater