access db comparing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnE - 06 May 2008 15:19 GMT

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

Reply to this Message

Damon Heron - 06 May 2008 15:45 GMT

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

> 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)
[quoted text clipped - 8 lines]
> Thanks.
> ... John

Reply to this Message

JohnE - 06 May 2008 16:09 GMT

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

> 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
[quoted text clipped - 18 lines]
> > Thanks.
> > ... John

Reply to this Message

Damon Heron - 06 May 2008 18:51 GMT

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

Damon

> Damon, thanks for the info. Do you happen to have the location of
> "Issues"
[quoted text clipped - 29 lines]
>> > Thanks.
>> > ... John

Reply to this Message

Klatuu - 06 May 2008 16:11 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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)
[quoted text clipped - 5 lines]
> Thanks.
> ... John

Reply to this Message

ridders - 06 May 2008 19:58 GMT

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

Reply to this Message