Today's Captain's Log is brought to you by... a jar of jelly.
Not some epic space anomaly or a philosophical showdown with Q. Just jelly. I sliced open the side of my right index finger on the sharp edge of the metal lid. And of course, it's the finger I use for everything: typing, tapping, swiping, unlocking my phone. No, not just picking my nose.
Anyhow... this finger is offline.
So here's your PSA: don't just rely on one finger.
Set up multiple fingerprints on all your devices. Thumb, pinky, left hand, backup left hand. One little cut and suddenly you can't unlock anything unless you've got a backup. Luckily I had a few other fingers registered, so I didn't get locked out - but it was a close call. And on my laptop I also have a PIN setup which is easy to remember... and yes, partially Star Trek related. LOL.
Also worth thinking about your passwords. I use Google's password manager, which works great for me. I know some folks - including my wife - aren't comfortable having everything stored in one place. And yeah, if someone gets into your Google account, they've got the keys to the kingdom. But at some point, you've got to trust the tech. If Google's getting hacked at that level, we're probably all in trouble anyway.
As I've said multiple times, you should never use the same password everywhere. But you've got to have some easy way to remember all your passwords. Or at least have them stored in a central repository.
And speaking of backups, this is exactly why Starfleet doesn't let just one person control the ship. There's always a second officer. Even Data has backup subroutines. You think they gave Worf the conn just for fun? No, that's planning ahead in case the jelly jar wins.
So yeah - protect your data, enroll your backup fingers, and don't underestimate the danger of pantry-based injuries.
LLAP RR
P.S. Shameless plug for my mouse pad. You know you want one.
As to the mouse pad, I was told, by some old Access wag, to always do a rs.MoveFirst as you can't trust that the rs will be at the first record. Is that not the case anymore? I would have called it a bug, but you never know with Microsoft.
If you, like Richard's SMART, new-wife don't like putting your life in the cloud, a local app called KeePass Password Safe is a great alternative. There is a version for Android too, so it's always available even if the Internet (or your finger) aren't available. Mentioned before in other threads.
Thomas Gonder
@Reply 2 months ago
Bonus, stupid dad joke:
Why do gorillas have such big nostrils?
Great question. It is safe to assume in Microsoft Access, when you open a recordset, that you're at the first record. However, this isn't always necessarily the case with other database systems, including SQL Server. But for Access, you're usually good.
Just like it's always safe to assume that a string variable that you declare is always initialized to an empty string. But I always like to manually initialize that myself just in case. S=""
And just like it's always safe to assume that when you exit a procedure, access always cleans up any object variables by setting them to Nothing. But I've seen first-hand that it doesn't. Hence, if you set it, you got to forget it.
So is it a good idea to MoveFirst? Yeah it can't hurt, and if your code's not working right that could be why. Access is supposed to start you at the first record, but you never know. I will admit with the mouse pad I was trying to put together the smallest possible recordset loop, but it can't hurt... just like it can't hurt to add some error handling.
Thomas Gonder
@Reply 2 months ago
Likewise, you gotta keep an eye on those arrays set to variant.
If you like testing for Nulls, it won't work because they are "empty".
Richard must have a video somewhere on all these little variable gotchas.
For most of my years, I worked in a database system that was record and not record-set oriented. When you wanted to work on a set of records, there was a natural query language, somewhat similar to SQL, but it created a temporary index (that was how we ran 30 users in 64K of core memory, no huge internal "temp tables" hogging up memory, just an index that could be paged to hard disk). When you referenced the index in code or another query, it ALWAYS started with the first record. Doh Microsoft!
Matt Hall
@Reply 2 months ago
Maybe someone needs to add band-aids to the swag shop. :)
UPDATE: I can use my finger again today. Well, mostly. As long as I stick to the side of it, I'm fine. It's not painful anymore, just mildly discomforting. My fingerprint recognition works if I stick to the side of the wound. If I push anywhere near where that gash is, then it doesn't work. So... Yay for the healing power of the body.
Maybe it was just me, but your index finger was not the "finger" that I thought you were talking about! LMFAO!!!
Thomas Gonder
@Reply 2 months ago
Sam He got me too. My first thought after reading just the title: One isn't enough?"
Michael Olgren
@Reply 2 months ago
I gotta plug Dashlane. By far the best password keeper I’ve used. Has a pw generator, secure notes section, autofill— the usual, plus you can get a family account and securely share notes and pw with them. Reasonably priced to boot.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Captain's Log.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.