Recent content by canyonraven

Hello! My coworker and I are seeing the Microsoft Access sessions freezing for 1 - 2 minutes during forms development (specifically with textbox editing) and also with VBA coding, where the session freezes during editing. I'm not sure if these two issues are related, but they are both on the...

Please forgive me if I gave the wrong impression earlier, I really do enjoy Access, SQL and VBA. Like the Doc Man's career path, I started with Honeywell mainframes and VAX minis with Fortran, then C/C++ on Sun UNIX boxes, early Mac's with Pascal, a few years integrating Oracle dbs with GIS...

VBA is not a big draw to new coders because Microsoft is not investing in it.

I certainly didn't mean to imply that MS Access doesn't use SQL.

By "eventually", I mean a decade or so. It's still a very, very long time as a software product.

Just at a glance, I would say use more (...)s to control the conditional statement and dissect it with comments to localize the problem.

Welcome Eprous. I'm new here too and have found this to be a wonderful forum!

I work in large organization where data is handled in small teams. There is definitely an age cohort associated with Access with most of the VBA developers being 50 and older. The younger developers continue to use SQL and relational databases but there is a trend towards Python and R and...

I've spent a lot of time worrying about how Access applications would survive migration to the cloud, when in fact, operating systems and the software they support seem to live on forever as cloud products. Just ask yourself, do people want and need this software platform. Judging from the...

I use the FMS Total Access Detective add-in regularly. The 2016 version works with O365. It does a comprehensive job of comparing two databases and its an "off-the-shelf" product, ready to go. Coding something like this for yourself would be a pretty big project (not that I would ever...

This forum is wonderful! I look forward to hanging out here. I work with a small group of environmental scientists. Access is our "meat and potatoes" for almost all of our data flow. It's fantastic to find so many others using it🙂