Search results

That is why you don't use Windows to secure your SQL Server. My users never have their credentials for the server database. While it is true that you can view linked tables, as long as you don't store the password with the link, you can't retrieve data that way or use the table names and...

Funny how a news rag that cleverly hid this information at the time, now is happy to trot it out.

No. Zero. DakotaRidge was proud of the thousands of objects he created in his application. I think he thinks that makes him smart or something and instead of learning about Access and database design, he was studying medicine.

For a long time, the hard sciences held the line against the wokeness overtaking the rest of academia but they also caved years ago when they realized they can't get funding for any research that will challenge the party line.

But we don't care any more. You're talking to a person who is no longer with us. Let it go.

That was why the suggestion included "cascade delete"

The data is not as unnormalized as it could be but the form proliferation makes it look worse than it is.

Again, all you need to do is to always use TransferSpreadsheet to link to the same named table. Then your queries won't break. You can first check the linked table using code that has an error trap so you can suppress the error message and just delete the link if it already exists. The reason...

A lot of the forms were built on queries that selected hard coded criteria. So, even though there was one table to hold all grocery stores (not quite normalized), there were separate forms for each named store so Walmart had its own form for reasons that were never actually explained. But...

PS, Just FYI, at Reader's Digest, I used Access to link to the DB2 version of their 60 million row master file and that was what sold me completely on the viability of Access as a tool with which to build production applications. Not only could I retrieve data from the huge DB2 table but I...

You're welcome. I won't wish you good luck. You'll need far more than luck to complete this project. Without any site preparation or a proper foundation, you'll need a miracle. But at least we won't be stressing you any more;)

You probably never asked a builder about site preparation or a proper foundation either. Both are required if you expect to build a second story. Or you can simply say, they don't interest me so I don't care about them. Pretty short sighted if you ask me. You also didn't learn the lesson I...

But you are expending ever so much energy on investigating medical data. Why not spend that time on learning Access instead?

Just so you know, if you use a CC or Debit card, you can download the monthly statements and import them to a database. Saves a lot of work. My checking account is with my investment account so all the cash is in a money market fund that pays the top short term interest rate which is just...

Ok, so you are now believing some scientists but not all. Exactly what I would expect;)

NO CITIZENSHIP --- EVER --- for anyone who entered the country illegally or who overstayed their visa. Once we get rid of all the criminals and as many of the newcomers as we can, we can negotiate something so that we don't have to deport families who have been here illegally for dozens of...

@DakotaRidge I don't want to divert this thread to COVID but on the news just now was the results of recent studies that are blaming the proliferation of new COVID boosters on the mutation of COVID and the fact that the more boosters you get, the more variants of COVID you are sickened by and...

If you properly tablize the various values for test ranges, it makes no difference whatsoever what the test is measuring. You find the row with the range that contains the value of the A1c, Blood Pressure, pulse rate, sugar level, etc. and the row value tells you whether or not to highlight...

No, they can't. You are not understanding the purpose of the split between application objects and data. If/when you make this split. EVERY table that includes data that can be updated by the user, gets put in the BE. NEVER in the FE - because, you want to be able to completely replace the...

That's because you do not understand what we're talking about. And you haven't looked at the table maintenance app and tried to understand it. The table maintenance app is very specific. It is for lists that have only a few, common, fields. The ONLY lists that are ever combined are the lists...