Update Table (2000)

Topic

New Reply

I’m trying to update a table via code….I’ve used this code many times….(in A97) tho…..I’ve made the reference to DAO 3.6.

My table name is tblComExport

The following is the beginning part of the code….which is where it continues to bomb:

Dim DB As Database*********Fine
Dim rsLog As Recordset***********Fine

Set DB = CurrentDb()**********Fine
Set rsLog = DB.OpenRecordset(“tblComExport”)**********BOMB***********Error msg***************Runtime Error 13 Type MisMatch
With rsLog************Don’t Know ***can’t get this far*****
.AddNew

Any ideas or suggestions would be appreciated.

Thanks.

Reply | Quote

Replies

Do you by chance still have a reference set to ADO, and it comes first in the references? That would cause the kind of behavior you are having. You can either remove the ADO reference, or you can explicitly your references as DAO. Just a shot in the dark.

Reply | Quote

You might also try specifying the recordset type such as dbopendynaset. This has solved some of my error messages when I’ve upgraded from 97 to XP.

Reply | Quote

I believe the problem is that you aren’t specifying the recordset type, as Paul suggested. It works in Access 97, but it is a bad habit to get into, and can cause blowups in 2000 and later.

Reply | Quote

Have you found the solution to this problem yet?
Pat

Reply | Quote