VB Code:
  1. Dim db As Database
  2. Dim rs As Recordset
  3. Dim ws As Workspace
  4.  
  5.     DBEngine.SystemDB = "C:\Documents and Settings\System.mdw"
  6.     Set ws = CreateWorkspace("NewWS", "user1", "", dbUseJet)
  7.     Set db = ws.OpenDatabase("C:\Documents and Settings\testimport.mdb")
  8.     Set rs = db.OpenRecordset("EquipAll")

This returns me a Runtime error '13': Type Mismatch
even though the return type of the OpenRecordSet function is 'Recordset' and the rs object is of type 'Recordset'

???