Getting value from 30 years of Access development.

[Royce]

Over the past 30 years I have collected 400+ objects, and over 30,000 lines of access VBA code that I call my "standard code". I've also written some Access Addins that I use in my development work. Some are very simple, one is pretty complex (I use it to export database code and objects for code reviews, and importing into other databases.) I also have a tool that allows me to select a set of features and then create a new database in one click with those features. I also have a set of MS SQL Server functions and procedures that I reuse.

In a few more years I will be retiring. I'd like to be able to make a little income off the code and tools, but have not been able to come up with an approach that seems reasonable.

Any suggestions?

 

[tvanstiphout]

My suggestion would be to think about this some more, before you spend a lot of time and money without the ROI.

I think most professional developers have such library, some better organized than others. I doubt they are your customers.

So you'll have to find customers among the up-and-coming. With that small cohort one potential problem is that they may not yet see the value of your code. Your library probably also imposes a certain way of thinking, starting with the naming convention, that could be an impediment. Add to that the fact that lots of code is already available for free online, and developers also more and more turn to AI to write at least the skeleton of code for them.
Lastly, I see the issue of how to reach your audience. Putting up a website with a Pay button is likely not enough.

 

[Royce]

My suggestion would be to think about this some more, before you spend a lot of time and money without the ROI.

I think most professional developers have such library, some better organized than others. I doubt they are your customers.

So you'll have to find customers among the up-and-coming. With that small cohort one potential problem is that they may not yet see the value of your code. Your library probably also imposes a certain way of thinking, starting with the naming convention, that could be an impediment. Add to that the fact that lots of code is already available for free online, and developers also more and more turn to AI to write at least the skeleton of code for them.
Lastly, I see the issue of how to reach your audience. Putting up a website with a Pay button is likely not enough.

Thanks for your comments. They express a lot of the concerns that made me decide to post here and see if I could get any creative ideas. (This is still the best Access forum that I know of.)

Thirty years ago a web site with a pay button is what others did. From what I can tell, only a few made enough for it to be worth the effort. Now, less so. As to the up-and-coming, do they even exist anymore? Adventure Works has code that works. But I would never use it out of the box. And the AI VBA code I've seen at first glance looks good, but every example has been buggy, or so simplistic as to be worthless. I've come across a lot of "beginner' databases, but the good ones were usually started 10 or 20 years ago, and are still around because someone knew what they were doing. I have had to update and modernize my code many times over the years.

I'm not sure it is possible to make a living as an "Access Developer" any more." I get most of my work because I can work with SQL Server, My SQL, talk to REST API's, and manipulate OFFICE Objects like Word, Powerpoint and Excel. I've also worked with C#, C++, and other languages so I recognize at least some of the limitations, and strengths of Access.

 

[Uncle Gizmo]

see if I could get any creative ideas

you might find this post interesting :-

Youtube Channel by Karl Donaubauer

In addition to several members who have YouTube channels (@isladogs ,@Uncle Gizmo,@sonic8 ,@strive4peace), all of which I have learned MUCH from - Access Powerhouse and MVP Karl Donaubauer has joined the fray with his own. I came across this bit of news on my morning rounds and hope you all find...

www.access-programmers.co.uk

 

[Royce]

you might find this post interesting :-

Youtube Channel by Karl Donaubauer

In addition to several members who have YouTube channels (@isladogs ,@Uncle Gizmo,@sonic8 ,@strive4peace), all of which I have learned MUCH from - Access Powerhouse and MVP Karl Donaubauer has joined the fray with his own. I came across this bit of news on my morning rounds and hope you all find...

www.access-programmers.co.uk

Thanks, It was interesting, and the info on how google has changed is very helpful. Unfortunately, I think I have a good quality steak but no "sizzle" to sell it. Can't even write a book anymore. Killed by AI, Google, StackOverflow, etc.