Search results

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.

I generate e-mails automatically by using an SMTP object. This works fine from my own computer but when I use a virtual server I receive the message "A program is trying to send an e-mail message on your behalf.." which I then need to allow manually. Is there any way to get around this?

I have a program that generates e-mails automatically using the SMTP protocol. My problem is that if I am working on the same machine, the e-mails being generating gain focus, so what I am typing goes into the automatically generated e-mails. Is there anyway to prevent the focus from shifting...

The Texas Heartbeat Bill provides a method that if upheld allows a state government to negate any constitutional right, in effect repealing the 14th amendment. The whole "private action" workaround could be used to ban guns for example. In addition, allowing lawsuits by anybody, for damages...

I have faced the same problem, which I solved by computing an average cost/lb for each zone and a per carton charge. The results were in a few % and I rounded it up to the nearest whole dollar. It was good enough for our purposes.

For more than a year, I have been using Selenium VBA to automate website interactions. Sometimes this works really well but for other websites there seems to be no way of getting the correct interaction to take place purely through Selenium. Yes, I know about frames. Can anyone suggest a...

My company recently moved and for 2 weeks we were relying on WiFi, using an SQL server backend. There was no corruption issue, but speed was a problem.

You should also review the spreadsheets and see if you can emulate them entirely in Access. You can do many Excel-like things in Access by using dlookup and formatted Reports.

I had converted the MDB years ago using an older version of Access that could convert it directly. Check with Microsoft for a converter.

Delete the linked table and relink it with all the fields. Then open the linked table in Access and hide the fields you don't want to see,

I used to have frequent problems with database corruption, which ended with a major office update last year. So the usual advice applies, make sure everyone is running the latest version of Access and update the old MDB files..