Comparation of two "like" mdb application

[Domac]

Hi,


I have a serious problem, I am forced to deploy my Access 97 application
using mdb file (Startup form , custom menus etc).
I think few of my 30 users are altering code behind form,modules and querys.
How to compare code between two "same" mdb applications???

I am using Speed farett wich is great for search and replace on single mdb
level, but how to find differences bettween two applications???
I would like to compare mdb application wich I have deployed and mdb what is
in use on paticular workstation.

Please help, I am sure that someone had the same problem.


Thanks a lot!

Domac

 

[Armen Stein]

Hi,


I have a serious problem, I am forced to deploy my Access 97 application
using mdb file (Startup form , custom menus etc).
I think few of my 30 users are altering code behind form,modules and querys.
How to compare code between two "same" mdb applications???

I am using Speed farett wich is great for search and replace on single mdb
level, but how to find differences bettween two applications???
I would like to compare mdb application wich I have deployed and mdb what is
in use on paticular workstation.

Please help, I am sure that someone had the same problem.


Thanks a lot!

Domac

Take a look at FMS Detective. It does exactly that.

 

[John Vinson]

I have a serious problem, I am forced to deploy my Access 97 application
using mdb file (Startup form , custom menus etc).
I think few of my 30 users are altering code behind form,modules and querys.
How to compare code between two "same" mdb applications???

If you're worried about users changing code in the .mdb file - don't
GIVE them a .mdb file! Convert it to a MDE, keep the master .mdb in a
safe place, and give them the .mde frontend. They won't be able to
make design changes.

Failing that, I concur with the recommendation of Total Access
Detective (www.fmsinc.com). Terrific program!

John W. Vinson[MVP]