Search results

Reminds me of a teacher school who threatened us with 'castigation and chastisement'(y)

AI is great but I much prefer the way my wife misunderstands thing !

This really is Rule #1 for any database you are considering. Possibly Rule #1a is that if you can do it on paper, do you get anything from doing it on Access? The the school example here almost certainly yes, but surprisingly often the answer is no.

As I said in my first post the importance of terminology to the thread of better security is low! I suggest we cease the dialog and agree to differ, as it is just niceties and if and when we need to use the terms we explain what we mean. I certainly don't wish the dialog to deteriorate as...

Sorry but this not the accepted meaning in security seervices - and incidentally why they are called factors. ID is the first factor, password the second. That's why the term three factor was invented in the 1970s. I agree it has suffered drift since - see Wikipedia for instance, which can't...

That's 3 factor.

I don't know if we have discrepancy between US and UK or just different individual usage but by my understanding AWF is 2-factor (userid and password). Not that this very minor question has any relevance to the threads emphasis on security, which I totally endorse.

As for three factor authentication just don't lose your mobile phone! Like the 400 a day in London!

I assume you are referring to fatuous - yet another everyday word! Yet again two countries divided by a common language to quote Winston Churchill.

'Dear' is a perfectly normal turn of phrase in English! Same as m'duck in Nottinghamshire, luv in various places and darling, mate etc. I also think that whole argument over the Canaries is fatuous .

Not only is data cleansing important but a data design is critical - understood that legacy data is a problem and a revised data design may not be possible, when a potentially complicated function may be the only remedy. Much, much to better to re-design the data if possible.

All in all I just wish Decimal was implemented as BCD as it was in PL/I. Each half bite was a number from 0 to 9.

Currency datatype which has certainly been in the JET/ACCESS DB Engine since to 90s and was defined as 8 bytes long in the oldest documentation I have (1998). The more controllable, but difficult to use JET/ACCESS DB Engine Decimal datatype has been around since at least Access 2010. The...

This is exactly why the Currency and Decimal Datatypes were invented. (Albeit using data stored as Decimal in a table takes a little manipulating in code to ensure the Variant datatype being used is formatted as decimal - eg, by using Cdec(...) etc.)

Follow on - just realised that ShellWait isn't a VBA function but one in the wsShell Object. Code that does the same in VBA attached.

The real question is how do you launch your Python program? If you launch it from Access then then you can refresh/requery your table as the Python program finishes. Just have to ensure that the program finishes before you update. (Use ShellWait rather than Shell to launch it.)

If you need anything more than Split() - perhaps multiple delimiters for instance - then use Regular expressions.

That was the empire, not UK. Why do you think we wanted an empire except to get warm!:cool:

Being a Brit can I ask one question? What's Sun?

If you read the documentation that used to come with Access, that was the design purpose of domain functions so Doc Man is absolutely correct. I don't think it ever occurred to me to use one in query!