How to Solve Error 3835 on Windows 10? Here Is the Tutorial

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.

Is Antivirus Necessary for Windows 10/8/7? Get the Answer Now!

Is antivirus necessary for Windows 10/8/7 to keep your PC safe? Read this post to get the answer, and you can also know some ways to prevent malware.

Read More

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.