using a version number to create a file name

[ProgramError]

Hello

I use version numbers while developing databases and save it in an admin table field. Each time i update the the program I often change the version number to indicate a minor or major change.

Does anyone knoe of a way the version number can be automaically added to the databases' file name and save it each time the number is changed?

for example the ususual database maybe "roombookings" and the version number maybe "2.01" in the admin table under the field name version, so I'd like to save the whole program as "roombookings_2.01"
Is it posible?


Program Error
Programmers do it one finger at a time!

 

[Trevil]

Hello,
Whenever you make the new version, something will need to trigger the save. The short answer is yes, you can save the file with the new name that includes version number. One method would be to write a little code that you can execute whenever you are ready that would grab the version number, create the proper file name, then compact and repair.

We have a similar approach to manage versions, but use a table to track version information (ver. number, date, changes made, etc.), then have a VB6 program that does all of the dull work (set startup form, hide menus, relink tables to production, create mde, place on FTP site, etc.)

35+ years of 'progress' -- can't we all just go wire boards again?