Ah, gotcha. Sorry you’re in that pickle 
I use Android, and my bank implemented this stupid idea on their app. I mean, who steals info via screenshot? Oh, bad guy, you managed to find a photo showing I am $$$ in overdraft? Well done. Good luck ripping me off, though, I’m kind of sad that you have my phone, not me… anymore.
Somehow I found a work around (sorry, I don’t recall which) so I can once again copy my full bank details including SWIFT code in a single image.
Might be related to my habit of immediately jailbreaking every new phone I get.
I’m fairly sure (around 70%, because I have never done this*) that Access itself can be a “proxy” interface for SQL Server.
In any case there are plenty of free SQL interfaces. I like DBeaver.
If, of course, you are allowed to use it…
* and of course, the fact I loath MS Access with the power of 1000 sloths.
So can FileMaker. The robust big iron of SQL, the elegance of FileMaker scripting and UI.
The problem with using Access as a front end for SQL Server is that it behaves like Access. It’s the behavioral stuff that’s the problem, not the row-and-column architecture itself.
I absolutely love Access. I wish we could get it on macOS.
I can get by with MariaDB and write some Objective-C front-ends, but nothing is as easy to use as Access. I’m not sure what the problem with it is?
I’m actually surprised that it’s still in use in a workplace. The IT folks started cracking down on “shadow IT” about 10 years ago, and we can’t write useful applications by ourselves anymore, and instead have to commision multi-thousand-dollar projects out of Mumbai and our subsidiary there.
Good god, man. Access is the devil incarnate (in software form)
Ok.
-
ODBC connection. Fairly normal, but only one at a time, fairly abnormal. That’s the major killer issue.
-
Not scalable, and thus an “all eggs in one basket” scenario, rather than sharding etc.
-
on that note, not easy to run two (or more) concurrent instances
-
Windows only
-
Microsoft themselves have declared “End of Life” but reneged. Future is uncertain.
-
max data size is 2gb/record… probably not a problem for most users, though even with SQL server I’d be questioning my database design at that size
I mean, there is a lot to hate.
MS SQL Server, MySQL, Postgres et al don’t have these issues. If we were to expand to NoSQL; well I have a bunch of criticism to make there too.
But Access… it is the Excel of databases. And Excel is my second least favourite software.
No, no, no, you’ve got it all wrong. It’s a desktop application, and all of your quibbles have to do with enterprise database management. It’s when people try to force it into a role it’s not designed for that it sucks. I can’t pull a 5th wheel trailer with my Mach E. That doesn’t mean my Mach E sucks.
For 60% of the shit people try to do with Excel, Access would be better.
Why can’t many web forms just ignore trailing spaces?!? For some reason, my browser’s autofill puts a trailing space on some of the things like my email address that it fills in, and it seems the majority of web forms don’t like that, and won’t consider it a proper address (or phone number, or whatever).
Isn’t it trivial to include code that just disregards trailing spaces?
Yes, remove_whitespace. It’s a library function in C and has equivalents in almost any other higher language.
Yes, totally. It takes 7 keystrokes to add to any form field. Less than that in modern frameworks.
Sadly, that and many other obvious web things have fallen victim to “web dev by committee”, where many sites are so bureaucratic that no one person really has ownership over a page anymore. Even a simple form was probably dreamt up by a VP, told to a division head, assigned to a product owner, chopped up by a project manager, assigned to an overworked user experience designer juggling 50 screens for 5 platforms, outsourced to five dev teams responsible for implementing it in 3 languages each, tested by the cheapest labor money can buy, and then marked as resolved along 200 other tickets that quarter so it doesn’t bring down the average completion time and cost someone their promotion.
If “trims whitespace” wasn’t in the initial acceptance criteria, nobody’s going to bother with it, and instead it’s going to cause a dozen other bugs discovered three months later, but hey, that’s another ticket and another chance at a promotion!
Yeah? Are you available for consultations? I’m stuck with it but I can’t make it do the simplest things, and my supervisor… she’s the proverbial one-eyed king in the land of the blind but she can’t make it do much either. I can describe the things I’m trying to do and you tell me what I ought to do to make those things happen, you tell me your rate for teaching and coaching me through it?
That’s fair, a lot of people rag on FileMaker because it doesn’t scale nicely to a trillion records and a thousand concurrent users.
I hate when websites do for the security questions NAME YOUR CITY OF BIRTH because then you don’t know if you need to put in the space or not if your city is two or three words.
What’s important there is not the site’s standards, but yours. However you answer, you need to be consistent about it.
Yes. My answers to all such questions are all lower-case, with spaces removed.
Yes, but my frustration lies with the browser/autofill function that is introducing those spaces for… reasons?
Yeah, I haven’t been able to figure out that part, either.
It’s actually not a standard library function, and the link you provided is a tutorial on how to write such a function, because, you know, it’s not in any of the C standard libraries.
Ah, sorry, I haven’t written C code for almost thirty years, so I misremembered. At least my point stands that functions removing whitespace from strings exist in many languages.