Im going nuts! :) (open.recordset)

[jmswe]

I want to access a table in my database for some editing

I use:

Dim rst As Recordset

Set rst = CurrentDb.OpenRecordset("table1&quot

An get error "type mismatch".

I guess i have missed to reference some library since i seem to have to manually reference a library for every thing i want to do.

What is wrong?

 

[oharab]

Make sure you have set a reference to DAO (go to tools references in a module window)
If you are using Access 2000 or above, you will need to change Dim rst As Recordset to Dim rst As DAO.Recordset

The reason for this is A2k uses ADO by default instead of DAO so you need to tell it which to use.

HTH

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[jmswe]

Well thats it..

Im using above 2000.... but how on earth should i have figured that out? Thank god for this place and your help!!

Sane again.

 

[oharab]

The only reason I know it is because of forums like this! I guess I am going to have to learn at 1st hand what A2k is like. I am supposed to be upgrading to it soon. :-((

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------