I am using Visual Basic 6.0 with Microsoft Access 2000
Looking up on the internet I fount this code:
Code:
Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As String
Private Sub Form_Load()
sPath = _
"path of database here"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers")
Set Data1.Recordset = rs
End Sub
This code was the microsoft website, but it does not work.
Website: http://support.microsoft.com/kb/238401
So any ideas people?
--
Zenax
EDIT: it works on my college version of Visual Basic but not at home, and I swear they are the same version. Perhaps cuz at college I am using MS Access 2003 where Im using 2000 at home
EDIT 2: I have tried reparing/compressing the DB at home but to no avail!