convert macros to modules

[Dave F]

I have an Access database, created by someone else, and I'm trying to look at
the VBA code behind various macros.

When I try to convert the macros to modules I receive the following error
message: "You do not have exclusive access to the database at this time.
Your design changes will not be saved." I click OK and nothing appears to
happen.

I'm not sure what exclusive access means (I presume it means others are
using the db?)

What's the easiest way to get away from the GUI-based macro designer and
just look at the code?

Thanks,

Dave

 

[Dave F]

I've answered this question for myself, thanks. I changed the security
settings for my login to allow me to open the db exclusively and then did so.
Now I can convert the macros to modules at will.

Access is slowly coming back to me!

Dave

 

[John Vinson]

I've answered this question for myself, thanks. I changed the security
settings for my login to allow me to open the db exclusively and then did so.
Now I can convert the macros to modules at will.

Just note that there IS no "VBA code behind macros". Unlike the situation in
Excel
or Word, an Access Macro is a self-standing code object (a rather limited
and obsolete one, IMHO); converting it to a module does not reveal existing
VBA code, but instead actually *creates* a new VBA routine, slavishly echoing
the steps of the macro.