Macros in Access 2007

[Amanda]

I have a user who creates macros in a database. They work fine. He saves the
databases to his C: drive. He returns the next day and they don't work. He
creates a new database using the same macros and they work. Any ideas?

 

[Tom Lake]

I have a user who creates macros in a database. They work fine. He saves the
databases to his C: drive. He returns the next day and they don't work. He
creates a new database using the same macros and they work. Any ideas?

"they don't work" is pretty vague. Do the macros give an error message?
If so is it the same one every time (and what is it?) or do the macros fail
in different ways. Is the database shared on a network or is it
in a folder only your user can access? Has the user tried to repair the database
before recreating it? Can you give us an example of one of the macros that works
and then fails? I hate intermittent problems like this. They can be much harder to
track down than problems that are consistent.

Tom Lake

 

[Amanda]

Tom,
He is running them right from his C drive - no network involvement.
His errors seem to all be numbered 2950. one says return without go sub
action failed. and another one says object or class does not support the set
of events.
He has not tried a database repair but will try that next time it happens.
He is experienced with Access enough that these problems only started when he
began using 2007.