Moshe Singer
asked on
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\folder\access.accdb; is makking a error
I am running VB.Net 2015, and I want to edit a 2016 database - 64 bit.
I am using the following code:
Dim concstr As String
concstr = "Provider=Microsoft.ACE.OL EDB.12.0;D ata Source=C:\folder\accessDB. accdb;"
Dim newcnct As New OleDbConnection(concstr)
newcnct.Open()
When it comes to this last line with the Open command, it generates an error.
I am using the following code:
Dim concstr As String
concstr = "Provider=Microsoft.ACE.OL
Dim newcnct As New OleDbConnection(concstr)
newcnct.Open()
When it comes to this last line with the Open command, it generates an error.
Is your VB.net application 64 bit ?
ASKER
It skips all the rest of the codes and then jumps out to the previous procedure that called this function.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is your VB.net application 64 bit ?
Visual Studio 2015 is still a 32-bit application
Visual Studio 2015 is still a 32-bit application
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It skips all the rest of the codes and then jumps out to the previous procedure that called this function.
If you keep the error message secret, we are still left guessing what the error is.
/gustav
<<I downloaded it. This is the header of the file
Microsoft Access Database Engine 2010 Redistributable
It did not help the problem.>>
We'll need some more information then. Is this a new install, new app, is your code running 32 or 64 bit, and of course as gustav said, what the error is.
It could be anything....
Jim.
Microsoft Access Database Engine 2010 Redistributable
It did not help the problem.>>
We'll need some more information then. Is this a new install, new app, is your code running 32 or 64 bit, and of course as gustav said, what the error is.
It could be anything....
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
1. Open the "My Project" page in Visual Studio.
2. Select the Compile option on the leftside listing.
3. Set "Target CPU" to "x86"
thanks
I changed to "x86"
it was the same it skiped the of codes
then I changed to "x64"
then I got this masseage
An unhandled exception of type 'System.InvalidOperationEx ception' occurred in System.Data.dll
Additional information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
2. Select the Compile option on the leftside listing.
3. Set "Target CPU" to "x86"
thanks
I changed to "x86"
it was the same it skiped the of codes
then I changed to "x64"
then I got this masseage
An unhandled exception of type 'System.InvalidOperationEx
Additional information: The 'Microsoft.ACE.OLEDB.12.0'
ASKER
I CHANGED TO "X64" THEN I INSTALLED AccessDatabaseEngine_X64.e xe
THEN IT WORKED FINE
THANKS A MILION
THEN IT WORKED FINE
THANKS A MILION
/gustav