Access-2007: editing code of linked database/addin not working (save not possible)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PHAG - 17 Apr 2008 12:16 GMT

We have converted an Access-97 application to Access-2007.
( common logic in a library-db: lib.accda and serveral clients linking to
this library-db)

In Access-97 there was no problem to change code from the linked-db
(lib.mda)
direct form a client (and save this changes)

In Access-2007 it is also possible to open this code an make some changes,
but the changes can not been saved !
This changes get lost on closing the client without a warning .

Is there any option to change this behaviour ?

Thanks in advance ...

Regards
Makus G., PHAG

Reply to this Message

Chris O'C - 17 Apr 2008 15:19 GMT

Don't edit a library database's VBA code from within the database that
references the library. It looks like you're saving your changes, but the
changes aren't permanent. As soon as you close the database, all library
code changes are lost. This behavior has been happening since at least
Access 97. I don't expect this to change, due to the complexities of the VBA
editor and the multiple versions of source code that Access controls.

To make permanent changes in the library database, first make sure everyone
is out of it, then make the changes, save and compile, and then close the
library database and let others open their databases which use it as a
library.

Chris
Microsoft MVP

>We have converted an Access-97 application to Access-2007.
>( common logic in a library-db: lib.accda and serveral clients linking to
[quoted text clipped - 14 lines]
>Regards
>Makus G., PHAG

Reply to this Message