[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Controlling Microsoft Access Databases with Subversion

From: Glenn Davy <gdavy_at_tpg.com.au>
Date: 2005-05-23 01:30:44 CEST

Hi Marijn
There are two ways you can do what you want (that I've found)...

1) application.loadfromtext and application.savefromtext
I wrote myself a plugin utility that worked fine for this - simply
dumped things out/reload them using these undocumented features (how
microsoft to hide the useful stuff) into a directory structure of text
files. I also extended it to dump tables out as csv (in 2003 xml works
event better), and to itterate commandbars and dump them out.

The textfiles could then be managed through cvs/svn as appropriate.

I hit a stop point with this when, (being a stubborn all or nothing kind
of guy) I found that commandbuttons created in the gui (1837) to open a
form can't actually be place programtically. Not a problem without
workarounds I know, but... arghhh - why would MS do that?!

2) SNV<->SCC
I tried 2 - 1 (no longer supported) kind of worked, and another "PuskOK
SVN/SCC proxy" worked perfectly. (though $29US). I hit a snag here when
using MDB files with linked backend tables in another MDB file taking
working in a file where the links don't have anymeaning cause the links
to not get included. This could just be a function of the access side of
things and probably has nothing to do with the utility. The advantage of
this kind of approach is it gets to use the access built in source
control hooks (i.e. check in and out from database container, and get to
see status icons next to objects), but you have to find the appropriate
access source control plugin for your version of access.

Hope this helps a little

Glenn

On Thu, 2005-05-19 at 16:54 +0200, M. Verkerk - wrote:
> Hi everybody,
>
> Does anybody has any experience with using Subversion to control the
> versions Microsoft Access databases, including queries, forms, reports
> or even data?
>
> Marijn
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
> For additional commands, e-mail: users-help@subversion.tigris.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Mon May 23 01:32:55 2005

This is an archived mail posted to the Subversion Users mailing list.