Error 3835 is an issue that you might see on Windows 10/8/7. It could happen due to various factors, including program conflicts, faulty graphics card driver, virus attack, low disk space, etc. Don’t worry if you are bothered by this error. Here, MiniTool Partition Wizard puts together some possible solutions and you can have a try.
Microsoft Access is a database management system from Microsoft. It combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
When an error occurs in your Microsoft Access application, Access provides an error number and description. Error 3835 is one of the Microsoft Access errors. It usually comes with the following description:
Microsoft Access Error 3835. The DISTINCT keyword cannot be used with the multi-valued field ‘|’.
Why does Microsoft Access error 3835 happen? Some of the reasons are listed below:
- There are programs conflicting with each other.
- There might be a virus attack.
- Your hard drive is running out of space.
- Your graphics card driver is outdated or corrupted.
- Your Microsoft Visual C++ package might be installed improperly.
Now, let’s see how to fix error 3835.
Solution 1: Kill Background Process
Some programs might interfere with others. Therefore, when you get Microsoft, you should close the programs running in the background to make sure your Microsoft Access application can run properly. And you need to:
Step 1: Press Shift + Ctrl + Esc to open Task Manager, a Windows built-in tool that provides information about computer performance and running software.
Step 2: Under the Processes tab, right-click each program running in the background and select End task.
After closing all the unnecessary programs, you can exit Task Manager and check if Microsoft Access error 3835 has been solved.
Solution 2: Run A Virus Scan
If you still encounter Microsoft Access error 3835, you might need to run a virus scan to check for the virus attack. You can use Windows Defender or any reliable third-party antivirus software.
Solution 3: Run Disk Cleanup
Another reason for Microsoft Access error 3835 is the low disk space. To solve the problem, you can run Disk Cleanup to free up disk space.
Step 1: Press Win + E to open File Explorer. Then right-click C drive and select Properties. In the pop-up window, click Disk Cleanup.
Step 2: In the Disk Cleanup for C drive window, check the items you want to delete and click OK.
Generally, most files and folders in Disk Cleanup are safe to delete. For more details, you can refer to What Is Safe to Delete in Disk Cleanup.
Solution 4: Update Your Graphics Card Driver
An outdated or corrupted graphics card driver could also lead to error 3835. In this case, you’d better install the latest graphics card driver. You can download it from the official website of the manufacture or follow the steps below.
Step 1: Right-click the Start button and select Device Manager.
Step 2: Double-click Display adapters to expand the category. Then right-click your graphics card and select Update driver.
Step 3: In the following window, select Search automatically for updated driver software. Then follow the onscreen instructions to finish the operation.
After installing the latest driver, you need to restart your computer to make the changes take effect.
Solution 5: Reinstall Microsoft Visual C++ Package
To troubleshoot error 3835, you might also need to reinstall the Microsoft Visual C++ package, as the error could happen if the package is installed improperly or incompletely.
You can go to Control Panel > Uninstall a program to uninstall the Microsoft Visual C++ package on your computer. Then visit the Microsoft support page to download the package according to your Windows version. After that, install the downloaded package manually.