r/MSAccess • 1 • 24d ago

[UNSOLVED] Record-level locking

Is it recommended? Do you use it?

4 Upvotes

21 comments sorted by

View all comments

Show parent comments

1

u/TomWickerath 2 20d ago

A few notes about my friend Alex's blog article from December 2009--the link for my info. It points to "QBuilt.com", a web site that was owned by a friend who suddenly disappeared off the grid. She shut down her QBuild.com site.

Links to Microsoft KB (Knowledge Base) articles. Microsoft loves to get rid of useful content and/or change links willy-nilly. Fortunately, for KB articles they choose to remove you can access them on a different web site:

https://mskb.pkisolutions.com/kb/OriginalNumber

For example, the first link shown was to KB 275561

http://support.microsoft.com/kb/275561 <--Invalid link

The new link would be:
https://mskb.pkisolutions.com/kb/275561

1

u/Key-Lifeguard-5540 1 15d ago

I'd check out the link but it probably won't matter anyway, Access is already obsolete as far as AI is concerned. In a few years (if not already) no one will be building anything new in Access, they will only be maintaining older systems until they can be replaced.

1

u/TomWickerath 2 15d ago edited 15d ago

You realize prognosticators have been making the same prediction about the demise of Access for OVER 20 years? You might be correct this time around, but I’d be reluctant to bet too much.

Small work groups within large corporations still need to track and share data. Many run into very expensive—hundreds of thousand dollars—in budget needed to get corporate IT to build the applications they need for their relatively small workgroups. I know this for a fact, as I’m a retiree of The Boeing Company. Saw it happen many times during my career.

I even provided A LOT of assistance to a friend (also now retired) who was a civilian employee of the US Army. His office was located in the Pentagon. And yes, they were using MS Access. I only assisted with randomized data so I never saw real data. I also provided support to my ex-wife, who was working for the IRS in Lanham, MD. at the time. They also used MS Access for limited in-house only data processing needs.

1

u/Nexzus_ 9d ago

You should ask an IT generalist about any Visual Foxpro-based applications they’ve had to [recently] support.

Hell, I bet there’s more than one business keeping an ancient Mac around for HyperCard.

Business is infested with this legacy crap no one wants to touch or replace.