Open other access database from button inside access database

[ConfusedMay]

Hi,

I've created an access 2003 database that has a form with button called "open complaint database." This complaint database is also in access 2003. Here is my code to open the complaint database

Private Sub cmdOpenDb_Click()
       Dim objAccess As Access.Application
 
         ' Open Access database
         Set objAccess = CreateObject("Access.Application")
         With objAccess
            ' Make the application visible.
            .Visible = True
            ' Open the complaint database.
            .OpenCurrentDatabase ("C:\complaint_2003.mdb"), False
            Set objAccess = Nothing
     End With
     Exit Sub
End Sub

when I click the button, I get this error "Microsoft office access has encountered a problem and need to be close. We are sorry for the incovenience" with send error report and don't send buttons.

I tested this code using access 97 to open another access 97 and it worked perfectly. Can anyone please help me on how to open access 2003 database from another access 2003, because I need to convert all my access 97 databases to access 2003?

Thank you in advance.

[Scott Price]

Hi, I'm using Access 2003 also, and copying and pasting your code (with the one change of making the path point to a valid database on my computer) works just fine!

Check your references to make sure all are where they should be:

I've got these six selected:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office 12.0 Object Library

Other than that, I would say you've got a possibly corrupted database, or a possibly corrupted install of Access.

This is a link to Allen Browne's website with suggestions on Recovering Corruption , and Preventing Corruption .

Regards,
Scott

[ConfusedMay]

Hi, I'm using Access 2003 also, and copying and pasting your code (with the one change of making the path point to a valid database on my computer) works just fine!

Check your references to make sure all are where they should be:

I've got these six selected:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office 12.0 Object Library

Other than that, I would say you've got a possibly corrupted database, or a possibly corrupted install of Access.

This is a link to Allen Browne's website with suggestions on Recovering Corruption , and Preventing Corruption .

Regards,
Scott

Thank you for the reply and yes it was my access installation problem. Once I reinstalled office it's working fine.

[Scott Price]

Glad you got it working! Thanks for posting back with the solution.

Regards,
Scott