Connect to MS Access database

  • Posts: 3
  • Thank you received: 0

Connect to MS Access database was created by samucaeq

Hello, guys.
Can I use Database Browser to open a MS Access (*.mdb) database?
If possible, how can I setup the connection?
I've tried to use ODBC connections, but could not managed to make it work.:(
I'm tryng to use a better database tool than MS Access, specially for build complex queries.
1 month 2 days ago #20342

Please Log in or Create an account to join the conversation.

  • Posts: 7972
  • Karma: 33
  • Thank you received: 497

Replied by admin on topic Connect to MS Access database

You can use OLE DB connection to connect to MS Access

Mike
1 month 1 day ago #20346
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0

Replied by samucaeq on topic Connect to MS Access database

Thanks for the tip, but I'm not able to find the provider you shown.
Is there a way to add more providers?
1 month 1 day ago #20349
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 7972
  • Karma: 33
  • Thank you received: 497

Replied by admin on topic Connect to MS Access database

For MDB files, you can use Microsoft JET 4.0 OLE DB Provider
Mike
1 month 1 day ago #20350

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0

Replied by samucaeq on topic Connect to MS Access database

Thanks, I'll try.
Best regards
1 month 1 day ago #20351

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies