Unrecognized Data Format - Get this error...

[dfarland]

Get this error when I run this code.
What is up?

Sub GetTable2()
Dim rs As Recordset
Set rs = DBEngine.OpenDatabase("C:\Sales\StoreDB.mdb&quot.OpenRecordset("Objects&quot
Range("A1&quot.CopyFromRecordset (rs)

End Sub

 

[johnwm]

It's probably a W2K or XP database and you're still using an older DAO provider.

Check in Tools | References to make sure you're using DAO 3.6


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'