access db comparing

[JohnE]

This is a general question regarding the comparing of 2 Access databases.
There are several of us that are working on the same db (front end mainly)
and we are not in the same office. What I am wondering is if anyone is aware
of any app or other means to determine differences there would be between the
same app? I would have the "master" version here at the main office but
would need to know what the other person worked on and modified/added so it
can be brought into the "master" version.
Thanks.
.... John

 

[Damon Heron]

i recently worked on a project that had three people coding. We used an
Access template called "Issues" that is a free db for tracking projects. As
long as there is a clear division of labor and assigned tasks, it is
relatively simple to bring the pieces together for testing.
On the other hand, if everyone is just working on any part of the db that
they want to, you could have a chaotic mess on yer hands!!

HTH
Damon

 

[JohnE]

Damon, thanks for the info. Do you happen to have the location of "Issues"
db that I can go and check it out?
.... John

 

[Klatuu]

The best way to handle this is to use Visual SourceSafe. It allows specific
objects within the application to be checked out. It also includes utilities
to compare different versions of an object.

 

[Damon Heron]

Here it is:
http://office.microsoft.com/en-us/templates/TC012186931033.aspx

Damon

 

[ridders]

Hi John

Try Winmerge - Open source software ideal for comparing different versions
of a database. Download from: http://winmerge.org/.
Very good for seeing what has changed between project versions, and then
merging changes between versions.

Cheers

ridders