[AccessD] Type mismatch error

The following code generates a type mismatch error when the table tries
to open. I am not seeing a problem since the code ran in another DB.
References are set for VB for Applications, MS Access 11.0 Object
Library, OLE Automation, Microsoft DAO 3.6 Object Library and Microsoft
Active X Data Objects 2.1 library. tbl Wells to Allocate is a native
access table. Thanks for the assistance

 

Function AllocationFactors()

 

Dim MyDb As Database, myds1 As Recordset

 

Set MyDb = CurrentDb()

 

Set myds1 = MyDb.OpenRecordset("tbl Wells to Allocate", dbOpenTable)

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.