• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 977
  • Last Modified:

CONNECTION STRING ACCESS (MDB) WIN 7 64 BIT

Hi All,

I try to access mdb (access database) from application:

1. I have install AccessDatabaseEngine.exe
2. I have install AccessDatabaseEngine_x64.exe

I use connection string :

1.  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdlGlobal.strDataAbsensiPath
2.   "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & mdlGlobal.strDataAbsensiPath

Both failed.

What should I do ?

Thank you.
0
emi_sastra
Asked:
emi_sastra
  • 3
  • 3
1 Solution
 
emi_sastraAuthor Commented:
Hi  pratima_mcs,

Still not found the solution.

Thank you.
0
 
Pratima PharandeCommented:
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
emi_sastraAuthor Commented:
The message is :

"The Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

"The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Thank you.
0
 
emi_sastraAuthor Commented:
Great.

It solved with :

in the properties of your VB application, go to advanced compile options and choose CPU target: x86

Thank you very much for your help.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now