Converting to 2000

C

Cindy

I have converted a database from Access97 to Access2000.
I can view data and display it. But when I go to save the
data useing

dim rst as DAO.recordset
Set rst = dbs.openrecordset("table",dbopenTable)
rst.index = "ID"
rst.seek "=","335"

I get an error saying it doesn't recognise the set rst
statement. If I omit the dbOpenTable it stops at the next
line saying that the statement is not supported.

Please help. Any suggestions would be appreciated.
 
C

Cheryl Fischer

Your "Set rst" statement may be failing because "dbs" is not defined. You
may want to try adding:

Dim dbs as Database
Set dbs = CurrentDB

hth,
 

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