Where's the Recordset..Edit

M

Manus Nemeth

Hello,

Our office is converting to Access 2000, and when I try to
edit a record in a recordset as in:
Dim rst as recordset
..
..
..
rst.movefirst
rst.Edit

I no longer get the edit option, just EditMode, which
isn't the same(and doesn't work). I have a great deal of
code that uses this option, I've tried the help feature,
but that doesn't seem to be working properly, at least not
yet. What library do I need to add to get this option
back?

The choices I've tried have not worked.

Thanks for you time.

Manus Nemeth
 
L

Larry Linson

It seems likely that you are encountering a References problem. In Access
2000 and Access 2002, the Reference to the DAO library is not set by
default. Open any module, on the menu, Tools | References, then find and
check Microsoft DAO 3.6 Library -- just in case you should miss qualifying
one of your users, move that reference above the ADO reference in the list.

Then, in your code, qualify the Dim statements for all DAO Objects, as

Dim db as DAO.Database
Dim rs as DAO.Recordset
Dim td as DAO.TableDef

etc..

If that doesn't correct your problem, please clarify/follow up here in the
newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top