I have a database that was developed in Access 2003 and had an issue when it was implemented on an Access 2002 system in a front end (FE) / back end (BE) arrangement. There is no password set on the code yet.
However, when I run it in Access 2002 and then try to edit the VBA code, it returns an unpleasant "Cannot View Code" and goes no further. It will not open the editor or, of course, any code. This same FE file on at least two other systems (albeit Access 2003 versions) can quite comfortably open the VBA editor and edit code.
Why would this occur? At first I thought it might be some references but of course I'd need to get INTO the editor to change or add. The strange thing is - everything runs OK on the 2002 version - code and data access is fine!?
Has anyone seen this problem - or have any ideas?