Opening Database [RESOLVED]

I am trying to open a database using a data control, however, I cannot use the OpenDatabase function. (yes, I am a noobie to VB.) How can I do this?

Code:

---

    ' Bring up a load window
    cdbDialog.DialogTitle = "Open database. . ."
    cdbDialog.Filter = "Database (*.mdb, *.xls)|*.mdb;*.xls"
    cdbDialog.FileName = "mydata.xls"
    cdbDialog.ShowSave
   
    If (cdbDialog.FileName <> "") Then
        ' Close the current database
        dtaMagicBase.Close
        ' Open the new database
    End If

---

what kind of datacontrol are you using ? DAODC or ADODC ?

I believe it is DAODC (the control that has the default name of Data1. )

I could use the ADODC if need be. I was thinking of putting the database in Access anyway...

I decided to go with an Access database and a data control, but I still cannot get back the database after I close it.

Morning Darkwraith, sorry to say, but I do not have any good suggestions on the subject.... (I don't use bound controls)

Before you go further with bound data controls, you should read this : http://www.vbrad.com/pf.asp?p=Articl...nding_evil.htm

;)

Good Morning (or night w/e the case may be) Peet.

I dropped the data control because I found that the FAQ was actually more helpful than my books :) and converted to ADODC.

If you have something for ADODC to open an Access database, it would be helpful and much appreciated.

The code is pretty much the same.

oh its morning :)

VB Code:

Dim sConnString As String
    
     ' Bring up a load window
    cdbDialog.DialogTitle = "Open database. . ."
    cdbDialog.Filter = "Database (*.mdb, *.xls)|*.mdb;*.xls"
    cdbDialog.FileName = "mydata.xls"
    cdbDialog.ShowSave
    
    If (cdbDialog.FileName <> "") Then
        ' Open the new database
        sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cdbDialog.FileName & ";Persist Security Info=False"
        dtaMagicBase.ConnectionString = sConnString
        dtaMagicBase.RecordSource = "Consumables"
        dtaMagicBase.Refresh
    End If

does the job :)

Thx! It works.

Question, though. Do I have to explicitly tell it to close or will it implicitly free whatever resources it took to open the previous database?

Dont think you have to close it. If you test it, and then open another db without the app crashing, then the new connectionstring has reset the data object.

Thx for the information!