Search results

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.

Dove's Theorem: The remaining work to finish in order to reach your goal increases as the deadline approaches. Brooks Law: Adding manpower to a late software project makes it later. Canada Bill's Moto: It's morally wrong to allow naive end users to keep their money.

Are you settings watches to monitor the value of variables inside the loop. If yes, the locals window will do the same for all variables in scope at the current line during debugging.

If you setup a AD domain account with local administrator access to those computers; you can run-as-admin the event viewer on your computer then select those remote computers. Your users will never no you are viewing their event list.

Yes That's exactly what I am looking for.

Once you switch from coding to testing, you will most likely fall out of the grove. But in any case adding a save step in regular intervals will quickly become automatic. PS: I use source control with Access and make a point to commit changes with each new feature.

I have been adding XML style comments to my procedure headers for a more structured comment system. It would be great if MS could enhance VBA, to use them in intellisence like in .NET. ''' <summary> ''' Check if user is member of an Active Directory group ''' </summary> ''' <param...

The video is an interesting animation but unrealistic. A living being has sensory organs on every part of the body. Move your hand, it can sense the movement of air past your fingers. A robot has non of that. It may have gyros to provide it better balance than a human but it can't match all the...