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
Expand|Select|Wrap|Line Numbers
- 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
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.