Manage code files outside Access?

Manage code files outside Access?

Post by McGeek » Tue, 10 Feb 2009 04:05:18


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
 
 
 

Manage code files outside Access?

Post by Piet Linde » Tue, 10 Feb 2009 07:48:34


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.

 
 
 

Manage code files outside Access?

Post by McGeek » Tue, 10 Feb 2009 08:09:50

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






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.
 
 
 

Manage code files outside Access?

Post by Albert D. » Tue, 10 Feb 2009 08:56:04


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://www.yqcomputer.com/

Access 2003 Source Code Contorl
http://www.yqcomputer.com/

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
 
 
 

Manage code files outside Access?

Post by Albert D. » Tue, 10 Feb 2009 09:02:00


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 (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
 
 
 

Manage code files outside Access?

Post by Albert D. » Tue, 10 Feb 2009 09:09:45

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


Should read:


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

Manage code files outside Access?

Post by McGeek » Tue, 10 Feb 2009 17:46:03

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
 
 
 

Manage code files outside Access?

Post by McGeek » Wed, 11 Feb 2009 18:48:09

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
 
 
 

Manage code files outside Access?

Post by Douglas J. » Wed, 11 Feb 2009 21:39:16

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.yqcomputer.com/
http://www.yqcomputer.com/
like eBay (although recognize that software purchased that way often isn't
legal)

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)
 
 
 

Manage code files outside Access?

Post by McGeek » Wed, 11 Feb 2009 22:46:00

Thanks Doug
 
 
 

Manage code files outside Access?

Post by McGeek » Thu, 12 Feb 2009 21:39:40

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!