Recordset type mismatch

[Killa]

why do i get TYPE MISMATCH if i declare rscopytable ?


Dim dbnames As Database
Dim RScopytable As Recordset

Set dbparts = OpenDatabase("L:\Part & Drawing Registers\database\parts.mdb&quot

Set RScopytable = dbparts.OpenRecordset(dbparts.TableDefs.Item(1).Name)

i want to get the fields.name and fields.count properties which i can only do if i declare rscopytable.



what i'm trying to do is make a copy of the tables in a database is there another easier way than interating through the tables then the records ????

 

[CCLINT]

Try:

Dim dbnames As DAO.Database
Dim RScopytable As DAO.Recordset