Version Control for VBA modules or projects? (1 Viewer)

Mike Krailo

Member
Local time
Today, 08:23
Joined
Mar 28, 2020
Messages
143
What does everyone use for versioning control on their projects. It would be nice to use Git but since I don't know where the modules are stored at I cannot set it up. Anyone have a solution for this? BTW, I completely new to versioning control in general and have blundered my way through without it for quite some time but it's time to get organized now.

I have two different locations that I develop at and it would be nice to have a central repository for all the code and track all the changes on various projects.
 

Micron

AWF VIP
Local time
Today, 08:23
Joined
Oct 20, 2018
Messages
3,471
I keep backups of the front end during development, file name & date of archive. How often and for how long would be personal preference and might be based on how much has changed since the last one. Unless you keep a separate db as a code library and call everything in it from a deployed fe, you really don't have a separate code file - unless you keep that as a document. I've never done that since I can keep all the code, query and report objects backed up as well. You never know when an object might get corrupted if it's being modified occasionally, so why not back up the objects as well? When I think I no longer need a version, it goes into my ToBeDeleted sub folder and I let it ferment there for a while.

EDIT - Forgot to say that since you mentioned working from different locations, I see no problem in storing a db on a stick or cloud - I just would never run it from either location.
 

Mike Krailo

Member
Local time
Today, 08:23
Joined
Mar 28, 2020
Messages
143
Thank you Minty, that filled me in on some the details that I was thinking about. And Micron, that's a good reminder about not running from the cloud. I have been looking into the separate db code library thing as well. One of my developer friends has one and just started using it successfully.
 

Lightwave

Ad astra
Local time
Today, 13:23
Joined
Sep 27, 2004
Messages
1,441
The 3 2 1 rule seems to be sensible
Store 3 backups
Ensure they are in 2 locations (2 devices)
Ensure 1 is off site

I just use rolling backup scripts that takes unique seconds / days / weekly / monthly and yearly backups of the whole database
Particularly useful functions I will write up on my blog
And happy to backup up things to sticks / google drive
 

Users who are viewing this thread

Top Bottom