Search results

Wondering if AI fits your Access development work? Get some insights from John W. Colby, who shared his successes (and a few frustrations). AP: Leveraging ChatGPT for Incremental Development in Microsoft Access

I started a request early Saturday, the 9th. ChatGPT 5.0 promised to complete it but offered no timeline. After 2+ hours I asked for a progress report. It replied along the lines of "I'm working on it." Over the next two days, I got a variety of firm deadlines, (2-4 hours, 4:00pm, and others)...

I agree, but the way I see it is that PowerApps and Power BI fit in where Access is not the strongest, i.e. remote data entry and data visualization. It's not three co-equal apps overlapping each other. It is finding the best fitting app for a specific kind of requirement and creating a hybrid...

I didn't plan them in any specific order because it's not oriented around a build process. I guess just sequential from oldest to newest for the Northwind series would be a good approach. The older videos refer to a library application I created a few years ago. It does more or less track the...

My primary use has been for Stored Procedures in SQL Server.

I should have noted that I find the form factor for a smart phone makes PowerApps sketchy, albeit possible. I've settled on a cellular-enabled tablet as the better choice. Maybe the 20-somethings with perfect eyesight can find stuff on a phone, and there are thousands of apps for phones. I guess...

Yes, use Lookup Fields where you would, in Access, add number fields for the Foreign Keys to the two parent tables and enforce RI. The Lookups should probably include only the required Primary Key field, no display fields, as is usually done in Lookups. For some use cases, PowerApps makes...

I arrive in Seattle in 1980. Different place now. 😆 I moved to Puyallup a year ago. Love it here.

Yes, that's why I was being nitpicky. It refers to someone in that SharePoint tenant. If it is a required field, and I think that's optional, then that might account for the error.

Or did you mean "Person or Group"? Or something else? SharePoint is a different environment.

Interesting, I'll have to try that. But is PEOPLE a multi-value or choice data type? Or what we might call normal datatypes in other databases?

Thank you. We will all miss UA. Right now, we have summer weather in Western Washington. In two weeks? Anybody's guess.

I agree on the naming convention for those fields. In fact, my first instinct was to double-check that one or both might be meta-data fields added by SharePoint to tables. It does include a number of such fields that are superfluous in Access. It may also be that the Lookup field...

The error message tells you the problem, in less than obvious terms. I can speculate about the problem a bit, but this would be subject to your verification about the field in question. In SharePoint lists, the concept of Primary and Foreign Key constraints is dissimilar to standard relational...

There may be licensed, 3rd party tools. I believe there was a presentation to one of the AUG chapters about such an add-in. Check the YouTube channel, IIRC, there is a license fee involved. Also, It may or may not be appropriate to what you seek. We also had a presentation at my AUG chapter...

No. ChatGPT is a liar.

Please confirm: Is your Access 2016 installation 32 bit or 64 bit? If it's 64 bit, you will need to recreate the mde (or accde) using 64 bit Access to be able to use the resulting accde or mde with 64 bit Access.

Does it have an accdb extension or an mdb extension? In which version was it created?

100% agree. I've been waiting for nearly 3 1/5 hours for a report. It is very extensive and ambitious, I know, but ChatGPT 5 has told me "another 15-30 minutes" for 2 hours now. I'm not sure if this particular request is really all that complex, or if it's just gone brain dead in the transition.

While migrating data from an accdb to a server database such as SQL Server is not a cost-free endeavor, it does address most of the security concerns for Access database applications. Comparing that cost to the cost of implementing a third-party application is an important part of the...