Recent content by isladogs

This is an extract from a lengthy article I wrote back in 2019: Query vs SQL vs Query Def As the article makes clear, there is no demonstrably 'best approach' and in the end, it comes down to personal preference. Speed differences between the various approaches are usually negligible despite...

@MajP I've not been following this thread so am unclear why you tagged me in the last post. Was that related to your upcoming AEU presentation? Or should that have been directed at @Edgar_ I often make use of popup forms to allow editing of read only data from complex forms such as that above...

You’re welcome but do take into account my previous comments about using additional security measures as appropriate to your needs.

The example app was written around 10 years ago as a simple replacement for an old MDB example app by David Crake that just used XOR to (weakly) scramble passwords. My version works but wasn't intended as a high security app. RC4 is indeed symmetric and therefore shouldn't be used (or at least...

Why not actually check whether any references are marked as MISSING?

I think you could also have used Me.Dirty = False

Unfortunately not , at least to me. Do you want to increase the height or width of the detail section? What does a 'singular line with no dead space between entries mean?'

Impossible for me to tell. The app has been in use for well over a decade. Did you unblock the app before use? Did you save to a trusted location or make it a trusted document? Are there any broken references? What version/bitness of Access are you using?

So did you look at the Password Login example app that I mentioned in post #21? That uses RC4 encryption and it definitely works. In fact I used something very similar for many years in my commercial apps for schools. The approach could easily be adapted for other encryption methods.

Yes I read that PDF. As already stated, I didn’t have any problems using that code. I sometimes use a combination of encryption and hashing. I also encode the cipher used with a different function for additional security

I would also recommend hashing password strings and the function provided by @the DBGuy is amazingly simple to use. FWIW, the dbgSHA256 function runs successfully for me with just the standard 4 references added in any new database in A365 I have .NET Framwork 4.81 in case that is relevant

Several years ago, I submitted a number of suggestions to the Access team which would improve the security of Access databases - in particular to make ACCDE files more secure. The first of those items was to mask the BE password. See my article...

Whilst the comment above is true, I don’t think that is the issue here @TheSearcher Did you relink the tables after encrypting the BE database? If not, do so. Also if you are storing user login passwords, make sure these are also encrypted using something like RC4 or SHA. This is essential for...

Ctrl+G opens the Immediate window which means the VBE is also opened. This is one of the settings you can disable via Access Options https://isladogs.co.uk/improve-security-2

Have you disabled shortcut keys such as Ctrl+G?