• Registered: 2017-05-15
  • Posts: 722

Topic: MS ACCESS

Hello MVD!

Is there a way or script to connect to Ms access Db?

Thanks!

  • Registered: 2014-02-14
  • Posts: 10,294

Re: MS ACCESS

Hello.


Check out this example
http://myvisualdatabase.com/forum/viewtopic.php?id=4241



But instead

Provider=SQLOLEDB;Server=myserver_name;Database=DatabaseName;UID=UserName;PWD=MyPassword

you should use

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\base.mdb; Persist Security Info=False

or

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\base.mdb; Persist Security Info=False;

More info
https://www.connectionstrings.com/ace-oledb-12-0/
https://www.connectionstrings.com/micro … le-db-4-0/

Dmitry.
  • Registered: 2017-05-15
  • Posts: 722

Re: MS ACCESS

Thanks DriveSoft!