Search results

I hope that the 2 million record table is not an Access native table. Such large table should be in heavy-duty database like SQL Server and linked to Access.

I do this sort of thing frequently. First you need to create some tables which have the correct fields you need to process the orders. Make sure you have a field for recording errors. You should also have a consistent place were you save the spreadsheet and link to it. The steps are then. 1...

You need at least 3 tables: Gauge, User, Calibration Gauge would be all the information you to describe the gauges. Your current Gauge ID# field would be the primary key. User is the Employee Names you already have. The Calibration table would be information you already have in columns D...

2206 is a beta build. How far should I roll back to fix this issue?

Thank you for making that clear, I was not aware of this being an Access bug.

If you delete a field in an SQL Server table, that can cause #Deleted issue when viewing the table in Access.

I did a web search on this, but no one had the same issue. People had some records or some fields with #deleted but no one had all fields & records affected.

I am suddenly getting values of #deleted in all fields in tables connected to 2 different SQL server databases, which have functioning for years. This affects most of the tables in the databases, regardless of the number of fields or records (I have 13 record, 2 field table that is affected) but...

I will check the Access build numbers when the user is off the system. I tested the same front end, not a copy of the front end.

Same front end & back end. Both are Windows 10.

A user is receiving the error message "Unable to update due to lock violations" when running a query that updates an Access native table with data from an SQL server table. When I run it from my computer, it works without any problems. We are running on the same network, using the same database...

I have found corruption in Access databases to be a problem even when there is only a single user logged in. The only solution is to move the backend data outside of Access.

It makes perfect sense for the quantity on a transaction to exceed the inventory. The transaction may be putting inventory into stock. You need to distinguish between inventory transactions and sales transactions.

Not all times in the history of the universe have an equal probability of intelligent life asking questions. The evolution of intelligent life requires stars of a certain size and stability. Ten Billion years from now, such stars will not exist.

Don't store barcodes as a number. Barcodes can start with 0.

For example, I could easily identify that an AB-11 & an AB-12 are similar by adding the ASCII values. But that wouldn't work for an AB-11 & an AB-11CS.

I need to use a query to find when products with similar ID's are in the same inventory location. Has someone designed a clever function that measures similarity? My idea is to add up the ASCII values of each character in the ID field and consider them similar if the totals are close.

Have you tried using Access's direct e-mail capability using DoCmd.SendObject? This requires a manual confirmation which can be dealt with by using ClickYes Pro or an Auto Hot Key script.

The exact same database works perfectly on my local machine. I think theDBguy is right, that this is a registry issue. I have created workaround using AutoHotKey.

Yes.