Search results

  1. piano_playr

    Does an Access query negate the benefits of utilizing SQL

    My mistake. The theoretical upper limit is 2 GB. Here is the cite. https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c#:~:text=2%20gigabytes%2C%20minus%20the%20space,be%20as%20large%20as%202GB. Really, my intention was to contrast the...
  2. piano_playr

    Does an Access query negate the benefits of utilizing SQL

    @Pat Hartman, you are hard to please. I compliment you and you dump on me. And you're meant to be a friendly moderator. :) I know all about Jet and ACE. They're built into the Access product. Whatever. Been that way for a long time. I was not comparing the two products. Reread my post...
  3. piano_playr

    Does an Access query negate the benefits of utilizing SQL

    @Pat Hartman is correct in pointing out the benefits of Access development. Having the ability to bind a dataset to forms and reports is a miracle. SQL Server is not a threat to Access. It cannot do what Access does. On the other hand, Access cannot do what SQL Server does. SQL Server is...
  4. piano_playr

    Fishing expedition by 1/6 commission

    It makes no sense to me to try to ascertain what these people were saying at that moment. If their actions violated laws, then they should be prosecuted. It does not matter what their stripes were; if they broke the law, they should be prosecuted. Who cares if they are MAGA, BLM, or Antifa? Who...
  5. piano_playr

    Fishing expedition by 1/6 commission

    Of course, I believe everyone should be granted the rights guaranteed by the constitution. President Trump is not evil or orange. I know what the Sixth Amendment guarantees. Unfortunately, the wheels of justice turn slowly for everyone, even though the framers preferred speedy trials. I...
  6. piano_playr

    Fishing expedition by 1/6 commission

    Do you realize sentences written in the second person singular are personal? I answered your question. I won't speculate about whether a particular court ruling is right or wrong. It is the decision of the court. When a decision is overturned by a higher court, then the original decision was...
  7. piano_playr

    Fishing expedition by 1/6 commission

    I am resisting looking at your posts as attacks on me personally. The thread is not about me. We have a good justice system. I prefer it to anything I've seen elsewhere. If a higher court overturns a ruling from a lower court, then the lower court got it wrong. It's not for me to decide...
  8. piano_playr

    Fishing expedition by 1/6 commission

    How does one know the untruths are not factual? Evidence? It matters if what they are repeating cannot sustain itself under scrutiny. In order words, if you have no proof someone or something happened, does it suggests it might not be true? Does proof consist of "Who actually saw, heard...
  9. piano_playr

    Fishing expedition by 1/6 commission

    Are you calling me a liar?
  10. piano_playr

    Fishing expedition by 1/6 commission

    Yes. Perjury is a crime. If he says he is not an agent of the federal government under oath, I believe him. Isn't that enough?
  11. piano_playr

    Fishing expedition by 1/6 commission

    To be clear, it's not the video that is being debunked. (We can get off track so easily here.) What is being debunked is the conspiracy theory that Ray Epps was a federal instigator who fomented the insurrection on 1/6. Ray Epps is a sixty-year-old man from Arizona. He runs a wedding and...
  12. piano_playr

    Fishing expedition by 1/6 commission

    I like both of these posts. Thank you @Steve R. This brings to mind another Lippmann quote I love: "It is often very illuminating...to ask yourself how you got at the facts on which you base your opinion. Who actually saw, heard, felt, counted, or named the thing, about which you have an...
  13. piano_playr

    Fishing expedition by 1/6 commission

    This is a conspiracy theory that was debunked.
  14. piano_playr

    Fishing expedition by 1/6 commission

    I've enjoyed reading this thread. It's easy to ascertain where each person's persuasions lie. I really like what Walter Lippmann promoted in the 1920s as good journalism. "There can be no higher law in journalism than, to tell the truth, and shame the devil.” -- W. Lippmann That quotation...
  15. piano_playr

    Fishing expedition by 1/6 commission

    Nobody lied. It's all true. Secret Service corroborated statements. Why are you having difficulty with the obvious?
  16. piano_playr

    Solved Showing/Adding Absent Students in Exam Results

    I agree with Pat's preference to use null as an indicator that the student had an excused absence on exam day. One can calculate an average of integer values where one of the values in the series is null. As Pat said, that's a better option than giving the person a zero. The zero is going to...
  17. piano_playr

    Rename Access tables dynamically

    May I propose the solution below? I am not going to attempt to talk you out of this. I assume you know what you're doing and this is what you want to do. Of course, this solution has no warranty of fitness for a particular purpose, an implied warranty of merchantability for products, or an...
  18. piano_playr

    Rename Access tables dynamically

    I use this procedure to trim "dbo_" from linked SQL Server tables when relinking. Access consists of collections and objects. It helps to review the Access object model. There is a collection called "tabledefs". Looping through it will let you rename tables using the .name property. Public...
  19. piano_playr

    Does an Access query negate the benefits of utilizing SQL

    It's an example. If the example is expanded to many more records with many more columns, the benefits become clearer. :-) There are so many more development features in SQL Server such as common table expressions, temporary tables, functions, triggers, table variables ... the list goes on...
  20. piano_playr

    Does an Access query negate the benefits of utilizing SQL

    I am a SQL Server aficionado. I love it. One of the neglected features of using Access as a front end and connecting to a SQL Server database on the back end is the programming available in SQL Server. One can execute SQL Server stored procedures on the server from Access. Most Access...
Top Bottom