Solved

Access 2002 - Error Code 461

Posted on 2004-10-09
2
313 Views
Last Modified: 2008-02-26
Converting Access 2000 VBA code to Access 2002 VBA Code

I trying to convert  Access 2000 code to Access 2002 code but I keep getting a complie error on a line of code in Access 2002, specifically, "Method or data module not found - Error 461". The code I'm getting the error on is - rsImport.Edit
Note: The same code is accepted bt the Access 2000 compiler.

Unfortunately I can't see what the problem is as the compiler accepts similar code - eg: rsImport.MoveFirst, rsImport.MoveNext and rsImport.Update.

Do I need to add something to the Reference objects in order for Access 2002 to accept the code? or does Access 2002 handle table updating in a different way to how it was handled in Access 97/2000
0
Comment
Question by:Adlerm
2 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 12269433
Hello Adlerm,

Have you checked your references - are any marked as missing?
Do you still have A2000 - are the references from your A2000 application all present in your A2002 application?

Pete
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 125 total points
ID: 12269637
Guess Pete's right on the money.
Best to define the recordset like:
dim rsImport as DAO.recordset

When there's no reference to DAO the "recordset" won't prompt after typing DAO.
A2002 by defaul assumes you're using ADO

Nic;o)
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now