Search results

Are the files in a public repository, or do you need to provide credentials to Claude?

Have you look at used laptop, tablet or phone screens. They would be cheap or free.

I ask Copilot, it said it could handle that much but cannot open an accdb. It recommends giving it .bas/.cls uploads. As for speed I think you would have time to make a nice dinner for all your friends while it works on it.

Which American? New York, South New Orleans, Florida, Midwest, Wisconsin, Michigan UP, South West, East cost Broadcast TV. They are all speaking in tongues.

I can't fine the original link but if you continue questioning your AI you will get to something like the following. Connection Scope: sp_setapprole applies only to the current connection. If Access opens new connections (e.g., for linked tables), you may need to re-activate the role for each...

I am uploading modules so not the entire FE.

Copilot and ChatGpt. I upload the text files generate by the Joyfullservice source control add-on. You could also copy and paste. Small code, copy and paste otherwise download.

I have been using it as a linter and for code review to refactor my code. Once it has my code I can ask specific questions for development. Also upload a document describing your coding standards.

App Roles will not work with an Access FE because of the way Access makes connections to SQL Server.

If you split the database, all you need to do is copy the new FE and link it to the 2nd BE.

An issue I found with W11 pro HyperV is it doesn't accept your workstations license on the VM, requiring you to purchase another one.

I have seen in a number of places that the SA account should be disabled on SQLServer.

You can implement version control for Access. It then becomes trivial using the built-in compare functions. I am using the following 1) Joyfullservice to export objects from Access to text files. https://github.com/joyfullservice/msaccess-vcs-addin 2) Git for Windows. linked to Git Hub...

This from CoPilot. ME > Is a 2021 ltsc office license legal to sold and used by individuals? Here’s the clear, grounded answer based on what Microsoft publicly states and what your question implies. 🧩 Is an Office 2021 LTSC license legal for individuals to buy and use? Short answer: Office...

If I use the OP's original date format DD/MM/YYYY in the immediate window. ?#29/12/2025# 12/29/25 Entering that format in the query window, Access converts it to US (On my US computer). ?dlookup("[RevDate]","feRevision","[RevDate]=#29/12/2025#") #12/29/25# Note the day must be > 12 for...

I would add a explanation why checking a range of dates on date columns with possible time is needed. "CheckIn >= #12/29/25# AND CheckIn < #12/30/25#" The time parts starts with 0 at midnight so a range of dates including the start date and excluding the end date will get all the times in the...

One thing missing in basic is short circuited boolean expressions like in C. I use nested if to put cheep test ahead of expensive ones.

I found that when working with AI and Access is to keep reminding it that you are looking for Access specific solutions. It tends to drop into VB or VB.Net type answers.

Franklin's Rule: Blessed is the end user who expects nothing. For he/she will not be disappointed.

The Last One's Law of Program Generators. A program generator creates programs that are more "buggy" than the program generator. Peer's Law The solution to a problem changes the problem.