Recent content by GPGeorge

Thursday, March 5th, 2025 6:30PM (Pacific, UTC - 8) I am not doing much Access work these days. Instead, I'm using Claude in the Cloud and Claude Code to work on other projects that interest me. It occurred to me a couple of days ago that because I have both versions of Claude readily...

Sorry I missed this one. Looking forward to the video.

Please re-read the various comments in this thread regarding the ill-advised use of "Last" in queries. Because it is unreliable, the alternatives, based on Max() or Min() values are almost always the safer method than "last", however, you choose to define it.

Post a request as a comment on the YouTube video. I'm not sure what his position would be.

Check here for the setting David called out:

While I agree with Colin that sample data and the actual SQL from the query can be highly useful context from which a proposal can be derived, others have pointed out the real culprit in this scenario, trying to use Last in a query. I won't belabor the point made so well by others. Use a sort...

What's the principle use case here?

The gotcha with that plan is that sooner or later, someone is going to either forget that they are supposed to copy the FE from OneDrive to their own computer, or decide it's too much hassle. And then the cycle of problems begins.

In most scenarios, I believe the preferred location is a folder on the computer used by the user. A copy of the FE should be copied to those folders for each individual user.

It's dangerous to try to run Access databases from OneDrive, or any other similar location such as DropDox. Others have written extensively of the reasons for this warning, so I won't repeat it again. I urge you to search out guidance on avoiding OneDrive with Access databases. One good starting...

Maybe it's echoing a script?

I apologize. My inarticulate statement about "the last AutoNumber" poured fuel on a fire that has smoldered for years and occasional flares up. What I wanted to express was the possibility that the most recently added record in a table may, or may not, represent the "last" record in a queue of...

Are we also potentially running afoul of the mistaken assumption that "the most recently added member " will always be the one with the highest value in an AutoNumber field? There are two aspects to understanding that question. First, it is true that Access will, by design, assign the next...

That's why, in similar databases, I implement a many-to-many relationship on Books and Genres, Movies and Genres, Music (tracks) and Genres. Let everyone have their preference.

Agreed. This line suggests something other than a real "porting" of an application. "The m-Power Development Platform brings your Access databases to the web using a simple and secure method. m-Power easily converts them into database tables, and then lets you build any type of application over...