Search results

I don't see were Plog was rude unless a post is missing, but stated that the code was hard to follow and provided a possible solution.

If they are not hybrid joined your local AD and 365 are operating independently. To login into the AD the computer must be joined to that domain. The compute does not need to be joined to 365, though they can be.

According to Microsoft SQL documentation the intermediate results will have the same type as the components. https://learn.microsoft.com/en-us/sql/t-sql/data-types/precision-scale-and-length-transact-sql?view=sql-server-ver17

Save edits before connecting to the telephone system.

500 controls on a single form points to a usability issue not corruption unless it also opens and hold locks on 100s of tables.

Intermediate rounding can case loss of precision. I would think the intermediate calculations like (A*B) would be determined by the types of A and B but even if they are Decimal(38,26) unless one or both had 26 digits to the right of the decimal or one or both are less than 1, rounding to 26...

I don't see using older computers causing a problem, unless they have problem network cards or are crashing while your application is open. I am just now replacing some computers this old but they have been connecting to a BE with 30 other users without issue. You may want to verify that none of...

For your customers with employees, properly securing the computers will help but if you suspect fraud, Access BE and possibly FE is the wrong tool. Let the owner know what's happening and what can be done to detect and possible prevent it. For single user customer, explaining the issue should...

Thank you for the reply. I'm not trying to be contrary. The only issue I have with your design rules is that from a quick reading of your query, it's not immediately obvious which ID is the primary key and which is the foreign key. Where if ID is always the primary key then your query becomes...

The query in strSQL only returns 1 column, the screen shot shows 3. Where are those other columns coming from? Also why are you setting the source this way, strSQL is not dynamic, you should be able to setup the sub-form source in the sub-form, using the links to filter it. After update could be...

You can trap network disconnects and shut down the application. Set the system time from the server time when the application reconnects. If properly configured the domain controller will reset the time within seconds of it being changed. If your users are intent to break you company...

Quick AI search got me to the following x64 code. 1) Net Time: Worked but was slow 2) WMI: Did not work because insufficient rights to make the WMI connection. 3) API: works and is fast. Provide your Domain controller server name. and replace the logger with your own. Option Compare Database...

I don't understand you issue. It's actually the default added by Access if you don't define a primary key. And Yes I know Access has some questionable defaults.

Note: I contract out for server support but do understand the process. On the domain control open "Group Policy Management", on your workstation OU configure "NTP Time from DC". Note: None of my users have local administrator rights on the workstation. This eliminates most of the damage a...

I did handle some of you issues in the "Northwind" sample I posted. In this case there are only 2 property tables based on type of property. Queries filtering on type allow me to line the data to join. I disagree on not using ID as the primary key. It's simple and directly identifies the...

I did use that type of structure for a sample database referencing Northwind. In this case I had 2 property detail tables, one for text properties and one for long. The long properties contained keys linking person and company ID and person/company addresses. In some ways the UI is simpler...

If your computers are joined to an Active Directory domain, they can be configured to get date / time from the server and disable the ability to change the date and time.

I have been playing with using properties MM table instead of storing 1M links in the employee table. This allows me to add properties without needing to touch the employee table. tblStatList could be moved into this system along with employee name and number. PropertyTableID would be the ID...

Are all the computers joined to the 365 domain and configured as corporate devices allowing 365 to manage those computers? This may be the difference between the computers that are working and those that are not. Check Intune devices.

I did have a issue with 2 forms that held a reference to each other. My solution was to add a public "Close" sub to each form, allowing closing the form though the reference before setting it to nothing.