Accecss Application Question

[uo]

We've inherited an MS Access application that needs debugging. However when
we try to open the mdb file (the actual database) the application runs and
we cannot see the database in edit mode. Question: How can we open the
database for editing and how can we access the code that is associated with
this application ?

Thanks in advance.

 

[Alex White MCDBA MCSE]

Before opening Access find the MDB file hold down either SHIFT button,
double click the mdb whilst continuing to hold down the SHIFT key, this will
show you the database window and you should be able to view/edit from there.

 

[Rick Brandt]

We've inherited an MS Access application that needs debugging.
However when we try to open the mdb file (the actual database) the
application runs and we cannot see the database in edit mode.
Question: How can we open the database for editing and how can we
access the code that is associated with this application ?

Thanks in advance.

Try holding the shift key down while openingthe file. However; if what you
have is an MDE rather than an MDB then you will not be able to view or
change any code.

 

[uo]

Thanks this works, I can view/edit the database but I can't find a single
line of code, i.e. how and where is the application logic implemented ?
There is nothing under macros.

Thanks again

 

[uo]

Thanks this works, I can view/edit the database but I can't find a single
line of code, i.e. how and where is the application logic implemented ?
There is nothing under macros.

Thanks again

 

[Alex White MCDBA MCSE]

Design view of forms then click on the menu at the top 'view' then the code
option.

modules within the database window, some people (like me) don't or try not
to use macro's so the application logic is in modules and form code.