Recent content by ButtonMoon

  1. B

    Is Microsoft Access a 'proper' database?

    So that would be a SQL Server database, not an Access database. The question here is apparently about Access databases and not about applications developed in Access.
  2. B

    Meaningless vs Meaningful Primary Keys

    Not my phrase. It was used by Mike Smart at the start of this thread. In fact I try to avoid the term "alternate" and I would usually just say composite key. According to Google Books there are 69 database and data modelling books containing the phrase "composite alternate key" and 8780 books...
  3. B

    Meaningless vs Meaningful Primary Keys

    isladogs, Thanks for correcting my syntax. You are right. You said you understand the terms alternate and composite. What else would you call a key that is both alternate and composite? Do you believe those two terms are mutually exclusive? Oddly the author of this thread seems to think that...
  4. B

    Meaningless vs Meaningful Primary Keys

    A composite alternate key is just an alternate key that has more than one attribute (nothing to do with foreign keys). For example, this table has two composite keys: (a,b) and (c,d). CREATE TABLE tbl (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT NOT NULL UNIQUE (a,b), UNIQUE (c,d));
  5. B

    Meaningless vs Meaningful Primary Keys

    A composite key is a key consisting of more than one attribute. An alternate key is just a key that isn't the "primary" key (alternate keys are sometimes called secondary keys, candidate keys or just keys). Unfortunately the power of myths often increases with age.
  6. B

    Meaningless vs Meaningful Primary Keys

    Where did this myth originate from? It is possible to create composite alternate keys and has been since at least 2003 (and probably before) as far as I know. There are multiple other misconceptions mentioned here but that is possibly the worst.
  7. B

    Books!

    Umm, perhaps the fact that it is a niche product which Microsoft has left in suspended animation for over a decade. In the same period the market-leading products covering some of the same core capabilities (rapid application development, data management, data analytics, reporting) have seen an...
  8. B

    selling your work

    It's worth clarifying the difference between selling an application and selling a database. Despite the question that started this thread, I believe this thread has so far only talked about selling applications, not databases. Legally and practically they are very different things. Generally...
  9. B

    Alternative non Server BackEnd to Jet

    A common back end in Jet is not a client-server database. My recommendation is that you use SQL Server, Oracle or PostgreSQL.
  10. B

    Alternative non Server BackEnd to Jet

    Every database ought to be implemented on a client-server architecture. The technology is ubiquitous, cheap and simple so there isn't much reason to do anything else these days. What is your objection to a server-based DBMS?
  11. B

    Re: lower/upper case in password

    Re: lower/upper case in password Here's a slightly more compact way of doing these comparisons: If Not password Like "*[0-9]*" Then err = err + "Password must contain at least one numeric character" + Chr(13) End If If StrComp(password, LCase(password), vbBinaryCompare) = 0 Then err =...
  12. B

    Security Access to SQL server

    When using SQL Server best practice is to use Windows integrated security. Don't use SQL logins or passwords. You can grant only the permissions needed for each user. They don't need to have the ability to delete or update data unless you want them to. No need to save passwords for linked tables.
  13. B

    Which one - Access Reporting or SQL

    The choice of SQL won't necessarily make much difference to the reporting experience. Possibly it will make reporting run quicker but that may be all. The choice of reporting tool is what really matters. There are lots of great reporting tools to choose from: PowerBI, Tableau, QlikView. Any...
  14. B

    Messaging Databse (deep breath)

    Access is not the right tool. How about using a web-based email service? I can't think of any good reason to develop your own messaging service. No disrespect but if you don't have something else more useful to do with your time then I think I would start looking for a new job.
  15. B

    Is there a way to change a primary key value

    Only if you enable the "Cascade update related fields" option. Tophan needs to enable that option on the relationship. Double-click on the relationship line in the Relationships window to see the option. Once that is done the update should be straightforward. As a rule, it usually makes sense...
Top Bottom