Manage code files outside Access?

[McGeeky]

Hi. I am sure the answer is no, but, is it possible to maintain code files
outside of Access? Its handy having all the files within Access when
distributing the database but not so great for development. I am from a C# &
Java background, used to having the code files managed as separate files in
source control where we benefit from version histories and parallel
development.

Thanks!

McGeeky

 

[Piet Linden]

Hi. I am sure the answer is no, but, is it possible to maintain code files
outside of Access? Its handy having all the files within Access when
distributing the database but not so great for development. I am from a C# &
Java background, used to having the code files managed as separate files in
source control where we benefit from version histories and parallel
development.

Thanks!

McGeeky

About the only thing you can do is loop through the modules collection
and the forms collection (to get to their modules) and use SaveAsText.

 

[McGeeky]

Thanks Piet. Is there a way to get them back in to the project using an
automated script?

Hi. I am sure the answer is no, but, is it possible to maintain code files
outside of Access? Its handy having all the files within Access when
distributing the database but not so great for development. I am from a C#
&
Java background, used to having the code files managed as separate files
in
source control where we benefit from version histories and parallel
development.

Thanks!

McGeeky

About the only thing you can do is loop through the modules collection
and the forms collection (to get to their modules) and use SaveAsText.

 

[Albert D. Kallal]

Hi. I am sure the answer is no, but, is it possible to maintain code files
outside of Access? Its handy having all the files within Access when
distributing the database but not so great for development. I am from a C#
& Java background, used to having the code files managed as separate files
in source control where we benefit from version histories and parallel
development.

You asking the wrong question!. The question is not can you have the files
separate. The question you ask is can you use source code control with
ms-access, and yes, we been able to do this...I think going back many
versions all the way to access 97.

So, you don't mention what version of ms-access, but you can most certainly
use VSS (visual source safe) with ms-access. It will thus will allow you to
check in/out forms, reports, code modules and even sql "queries". (heck, you
can't even check in/out your queries when using sql server...so, this very
cool).

Here is some info:

Info linik
http://support.microsoft.com/kb/837136/en-us

Access 2003 Source Code Contorl
http://www.microsoft.com/downloads/...f4-a916-48c5-8f84-44b91fa774bc&displaylang=en

For 2007 you simply have to install the developer extensios, and you then
also be able to sue source code ocnotrl...

 

[Albert D. Kallal]

Thanks Piet. Is there a way to get them back in to the project using an
automated script?

Sure you could. (one could even use windows scripting to do this). However,
you don't have to because someone already done this for you (Microsoft).

What that feature "hints" to is that any single object can be exported as an
text object. The end result you can use source code control products with
ms-access.

See my other post in this thread, but you can use VSS with ms-access. The
result is not only source code control, but you can thus have more then one
developer working on the application. So, you not get versioning of your
software, but also can have more then one developer working on the
application...

I not tried source code control with anything other then VSS, but if other
products are compatible with the standard source code control for Microsoft
products, then there little reason why other products can't be used with
ms-access.....

 

[Albert D. Kallal]

So, you not get versioning of your
software, but also can have more then one developer working on the
application...


Should read:

So, you not only get versioning of your

software, but also can have more then one developer working on the
application...

 

[McGeeky]

Hi Albert. That's great news, much better than exporting/importing the
files!

Thank you for your advice! I'll look in to this straight away.

McGeeky

 

[McGeeky]

Hi Albert,

For one project we are using Access 2000. I read that we need Office 2000
Developer which comes with a source control add-in for Access 2000.

Do you know how I can get Office 2000 Developer? I can't find anywhere to
buy it.

Is the Access 2000 add-in available separately?

Thanks!!!

McGeeky

 

[Douglas J. Steele]

Microsoft would have stopped selling it shortly after Office 2002 was
released.

I believe your only options would be to find a supplier who specializes in
discontinued software such as http://www.emsps.com/oldtools/ or
http://www.recycledsoftware.com/servlet/StoreFront or else look at someplace
like eBay (although recognize that software purchased that way often isn't
legal)

 

[McGeeky]

Thanks Doug

Microsoft would have stopped selling it shortly after Office 2002 was
released.

I believe your only options would be to find a supplier who specializes in
discontinued software such as http://www.emsps.com/oldtools/ or
http://www.recycledsoftware.com/servlet/StoreFront or else look at
someplace like eBay (although recognize that software purchased that way
often isn't legal)

 

[McGeeky]

A quick update - I now have a fully automated build for our Access database
and integration with our source code control system Subversion.

Its a bit clunky having to export and import all the Access files but it
works OK and now gives us the necessary version controlling of files that we
needed.

Thanks to those that helped!