Access 2002 - Error Code 461
Posted on 2004-10-09
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