problem with vb and MS Access
I've got a button in a vb form and got a MS Access application.
The MS Access database has many tables, Queries, Forms and Reports.
When I try to invoke a form or a report or a table from my vb application the MS Access is not running.I've wriiten the code in the click event of a button in VB.The code is as follows:
************************************
Private Axs As Access.Application
Private Sub Command1_Click()
Set Axs = CreateObject("Access.Application")
Axs.OpenCurrentDatabase "c:\windows\desktop\converted_new.mdb", False
Axs.DoCmd.OpenTable "Customers", acViewNormal, acReadOnly
End Sub
************************************
also I addes the MS Access 9.0 object library from the VB references.
on clicking the button in the vb form,the cursor blinks and after sometime it stops blinking and nothing is happening.