You can connect your Access Table with your VB form using different method. By using ADO, you can connect like this:
You have to select "Microsoft ActiveX data Object 2.0 or higher" from the preference of your VB.
Then, write this code in the module section:
Public ConnectData As New ADODB.Connection
'For making Connection
Public Sub Connect2DB()
Set ConnectData = New ADODB.Connection
ConnectData.Provider = "Microsoft.Jet.OLEDB.4.0; Data Source = " & App.Path & "\Your AccessDatabase Name.mdb;"
Whenever you need connection, call this connection by wringting "Call Connect2DB"
You need to update your recordset. If it doesn't help then it may possible your database has been corrupted. Try compact and repair utility to repair your database. If you're still not able to repair the mdb file try Stellar Phoenix access recovery tool. This access repair software repair corrupted access database file and mdb files.