Timeline for SQL Database vs Multiple Microsoft Access Databases
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 16, 2022 at 12:30 | comment | added | J.D. | @ArpiSz Eh, there are many reasons to use a more modern database system, and IMO an enterprise one like SQL Server which is highly built out with a multitude of features that other database systems such as MS Access doesn't have. But that's not to say some people don't have use cases where MS Access is all they need. I agree with with ypercube too, that MS Access is relational, I just personally am of the opinion it's a dated technology with better alternatives. | |
| Jul 16, 2022 at 8:56 | comment | added | ypercubeᵀᴹ | I see what you mean @Heinzi . | |
| Jul 16, 2022 at 8:55 | history | edited | ypercubeᵀᴹ | CC BY-SA 4.0 |
added 14 characters in body
|
| Jul 16, 2022 at 7:23 | comment | added | Heinzi | @ypercubeᵀᴹ: See, for example, the comment threads at stackoverflow.com/q/15499145/87698. Personally, I agree with you. | |
| Jul 16, 2022 at 3:46 | comment | added | user255698 | You are right. Actually there are dozens of them: en.wikipedia.org/wiki/… So why use Oracle, IBM DB2, Teradata or MS SQL Server? Pointless. MS Access is just as good! Actually I started my career with dBase. That is good too! | |
| Jul 15, 2022 at 22:47 | comment | added | ypercubeᵀᴹ | Really? Based on what grounds? It has primary key, unique and foreign key constraints as far as I know. Surely not all the capabilities of SQL server but I don't see any argument why it can't be called relational. | |
| Jul 15, 2022 at 20:34 | history | edited | user255698 | CC BY-SA 4.0 |
added 8 characters in body
|
| Jul 15, 2022 at 20:11 | comment | added | Heinzi | @ypercubeᵀᴹ: In theory, you're right. In practice, this is a touchy subject, and I've seen more then one flame war sparked by whether one may call MS Access a relational database or not. | |
| Jul 15, 2022 at 19:21 | comment | added | ypercubeᵀᴹ | Both SQL Server and Access use SQL so one is as relational as the other. | |
| S Jul 15, 2022 at 19:15 | review | First answers | |||
| Jul 15, 2022 at 23:43 | |||||
| S Jul 15, 2022 at 19:15 | history | answered | user255698 | CC BY-SA 4.0 |