Viewing 15 posts - 46 through 60 (of 515 total)
>> IDENTITY() is a piece of automation that solves a set of tricky problems for you. <<
Actually, IDENTITY creates problems rather than solve them. Essentially, you've decided to throw...
December 3, 2019 at 1:42 pm
At least someone's looking at it...
With sensors (especially cheap sensors) not only do you have exposure from the network you also have to worry about physical compromise. Why hack a...
November 25, 2019 at 1:15 pm
What I don't agree with is your enthusiasm for implementing Access apps. Any "genius" that you see in Access is confined to the workstation. I can completely understand how...
November 22, 2019 at 9:29 pm
... From a developer standpoint Access STOMPS Visual Studio...
I have a few issues with your post overall, which have been brought up by others, but I'm going to...
November 20, 2019 at 5:08 pm
I have never done any development on Access, but I have sure been called to consult for a lot of Access applications. On many occasions, I have had the...
November 19, 2019 at 4:32 pm
But T/SQL *sucks* as a language, and having to learn two distinct languages to do a single project is insane.
Wow. One can do nearly everything except build windows...
November 19, 2019 at 3:12 pm
I love Access, and always have, but I will admit to it having two critical problems that killed it, both Microsoft's fault.
First, Access stores its built-in security system passwords in...
November 19, 2019 at 2:27 pm
Let me hop in on the side of surrogate keys as clustered keys (usually INT identities). Unless you have to worry about aggregating independent databases (say, from multiple client companies...
November 18, 2019 at 1:41 pm
Dr. Codd defined a surrogate key as being generated by the database engine and never exposed to the users. What he had in mind would be more like a...
October 16, 2019 at 12:29 pm
Using the Employee table as an example: What if you need to have an unique index on the social security number to prevent duplicates. Would that not mute everything? ...
October 15, 2019 at 12:48 pm
We're still using an app written in MS-Access in 2002 as our main database. 100k lines of code, and its only now that we've started hitting the wall of Access...
October 11, 2019 at 12:52 pm
Speaking as a lone wolf, (developer, dba, etc.) there's the likelihood that if I'm hit by the proverbial bus every bit of the IT "staff" knowledge goes instantly *poof*.
Therefore it is...
October 2, 2019 at 12:45 pm
You need to be careful extending hardware techniques to software. For one thing, hardware tends to be limited by the nature of physicality itself. Hardware devices are made of simple...
October 1, 2019 at 12:39 pm
I think the question is broken, the correct answer is 'Jan 18 2019 8:23PM'
🙂
September 27, 2019 at 12:41 pm
Viewing 15 posts - 46 through 60 (of 515 total)