Cannot import/export or copy forms, modules etc

  • Thread starter Thread starter HollyS
  • Start date Start date
H

HollyS

A friend gave me her database to help her with (she barely knows access but has
been developing this for a while) .

When I try to import or export the forms (or even cut & paste them) I get this
message:

'The database has been placed in a state by user "Admin" on machine "XYZ" that
prevents it from being opened or locked.'

I have looked at the security stuff and I just can't see where this has been
"placed in this state"?? She says she never put a password on it - does anyone
have any ideas why I would have this problem?

Thanks in advance for any help!
 
Hi
Seen the message, and the scenario is nothing to do with security.
a) If you make changes to forms and then run VBA code that is trying to open
the db again. Solution - save everything before running code.
b) If the db opens a connection and doesn't close it, i.e. when you're
stepping through code, stop and make changes - but the run mode is not
stopped by Access - when you resume. Solution - close the connection in the
immediate window.
HTH
Marc
 
Back
Top