OpenDatabase()-AcitveX can't create object

[CrAz3D]

I keep receiving the error "ActiveX can't create object

I know that the path is correct & that Ham.mdb does, in fact, exsist.  Any ideas?

Code Select Expand

Global TresDB as Object

Code Select Expand


Set TresDB = OpenDatabase("C:\Documents and Settings\Owner\Desktop\Ham.mdb")

[Adron]

Perhaps your database drivers aren't correctly registered? Which one is it you're trying to use?

[CrAz3D]

Hmm.  I'm just trying to open Ham.MDB, a regular Access database located on my desktop.

Something that COULD be confliciting also, I "do not have a license" to use a data enviroment in ANY project on my computer.  I've reinstalled VB twice now & I am thinking that solving this could solve the OpenDatabase error, or @ least bring me closer.

[Adron]

Something that COULD be confliciting also, I "do not have a license" to use a data enviroment in ANY project on my computer.  I've reinstalled VB twice now & I am thinking that solving this could solve the OpenDatabase error, or @ least bring me closer.

Do you have VB Pro? IIRC, in some VB versions, opening a database without any gui object attached to it was restricted to the Pro version.

I'm still wondering where your OpenDatabase function is coming from, go check that?

[CrAz3D]

This is just code I am editting from the previous person that worked on it.  It is a fundraiser database for my school band, I'm not sure where they got the OpenDatabase Function.


Licensing issue fixed.

OpenDatabase is prob now.

[Grok]

Licensing issue fixed.

OpenDatabase is prob now.

What does this mean?  You didn't answer Adron's valid questions.  What edition of VB is this?  Pro?  Enterprise?  Warez or legit?

What are the listed references in the menu Project|References?

It's quite possible your scope includes multiple OpenDatabase functions, or at least the wrong one than you are expecting.  Which technology are you expecting OpenDatabase to come from?  DAO?  3.5? 4.0? 4.5?  Depending on your answer, is the proper typelib selected in references?

If you want help you have to give the helpers more than enough information.  Try to guess what we would need to solve the problem, then give that and more!

[Grok]

Code Select Expand


   Dim sDB As String
   Dim wrkJet As Workspace
   Dim TresDB As Object
   
   ' Create Microsoft Jet Workspace object.
   Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
   
   sDB = "D:\VS6\VB98\NWIND.MDB"
   Set TresDB = wrkJet.OpenDatabase(sDB, True)


works fine here with Microsoft DAO 3.6 referenced.

[CrAz3D]

Licensing issue fixed.

OpenDatabase is prob now.

What does this mean?  You didn't answer Adron's valid questions.  What edition of VB is this?  Pro?  Enterprise?  Warez or legit?

What are the listed references in the menu Project|References?

It's quite possible your scope includes multiple OpenDatabase functions, or at least the wrong one than you are expecting.  Which technology are you expecting OpenDatabase to come from?  DAO?  3.5? 4.0? 4.5?  Depending on your answer, is the proper typelib selected in references?

If you want help you have to give the helpers more than enough information.  Try to guess what we would need to solve the problem, then give that and more!

My ignorance.  Visual Basic 6.0 Professional Ed, from Hastings w/a student discount.

I'll try using the wrkJet method you listed above, thank you

[CrAz3D]

Grok, in your code, what is the Workspace?
Is it the data enviroment?

[Adron]

A Workspace is one of the DAO classes. IIRC it represents a session to DAO, in which you can have open databases/connections. Transactions are local to a workspace. I also think you can have different usernames active in different workspaces.