Getting "accessviolationexception" error after ms access 2016 installation

Question

0.00/5 (No votes)

See more:

, +

Hi,

Earlier ms access 2013 version was installed on machine. Now, ms access 2016 version has been installed.

I didn't make any changes in code, but i am getting "a first chance exception of type 'system.accessviolationexception' occurred" error.

I am using Microsoft Visual Studio Professional 2013 with vb.net code and ms access 2016 version.

Kindly suggest you ideas in vb.net.

Thanks & Regards,
Saurav Sinha

What I have tried:

I have change something with properties but didn't work. Also, tried below steps -

Tools menu ->Options -> Debugging -> General -> Uncheck this option "Suppress JIT optimization on module load"

not working for me.

Posted 20-Sep-18 18:35pm

yash1507

Updated 20-Sep-18 19:54pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-09-20T19:55:00

Solution 1

You get an "Access violation" error when the process trying to open a file does not have sufficient permissions for it. So start by looking at the file you are opening, the folder that contains it, and see exactly where it is, and what users have access rights. It's possible that Access 2016 uses a service which runs under a different user that the 2013 version didn't and so the file is not available.

If the file is under a User account ("My Documents" for example) then it may only be available to your specific user. Or it may be in your application folder, which is always a stupid idea! :laugh:
Try moving the DB to a new folder which has specifically been given all user all access and see if that improves things. This may help: Where should I store my data?[^]

Posted 20-Sep-18 19:55pm

OriginalGriff

Comments

yash1507 21-Sep-18 2:25am

Thanks OriginalGriff for your suggestions.

It's not working for me. I have kept that file in admin account and confirmed that the user have admin rights.

Below is the error message -
A first chance exception of type 'System.AccessViolationException' occurred in exe.
Additional information: Attempted to read or write protected memory. This is often and indication that other memory is corrupt.

i think somewhere ms access 2016 is not allowing the vb.net program to read/write. I didn't make any changes with the code, but it was working fine with ms access 2013.

Can anybody suggests some more ideas.

Thanks & Regards,
Saurav Sinha

OriginalGriff 21-Sep-18 3:17am

That's different - it has nothing to do with a file.
In future, give us the whole error message: "Attempted to read or write protected memory. This is often and indication that other memory is corrupt." is important - it means that how you are calling something is wrong, not the file you are using.
At a guess, it's bad parameters, but the only way to find out is to use the debugger to find out exactly which line of your code it's complaining about, and look at exactly what you are passing as data to what.
We can't do that for you - you need to use the debugger on running code!