{"id":2203,"date":"2020-06-09T19:35:42","date_gmt":"2020-06-09T11:35:42","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2203"},"modified":"2026-03-17T14:28:18","modified_gmt":"2026-03-17T06:28:18","slug":"connection-string-ms-access","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/connection-string-ms-access","title":{"rendered":"Connection String for MS Access"},"content":{"rendered":"<h3 dir=\"ltr\"><strong><img decoding=\"async\" src=\"https:\/\/ozeki.hu\/attachments\/1501\/connection-method.webp\" alt=\"How to setup Microsoft Access database connection\" \/><\/p>\n<p>Connection String for MS Access<\/strong><\/h3>\n<p dir=\"ltr\"><a href=\"https:\/\/www.connectionstrings.com\/access\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Connection String<\/a> is a string which contains database connection information. Then,\u00a0 it will be passed to the Driver Manager and driver (ADO) directly.<\/p>\n<p dir=\"ltr\">Beside that, The connection string need to be formatted as below form:<\/p>\n<p dir=\"ltr\">Argument1=Value1; Argument2=Value2; Argument3=Value3;\u2026;ArgumentX=ValueX<\/p>\n<p dir=\"ltr\">Example:<br \/>\nProvider=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=SamplePassword; DBQ=C:\\Domains\\sample.net\\db\\sample.mdb;<\/p>\n<p dir=\"ltr\"><em>Please refer to the following article to know more.\u00a0<\/em><br \/>\n<strong>Knowledge Base: <\/strong><a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/connect-to-ms-access-database\/\">Connect to MS Access Database<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Connection String for MS Access Connection String is a string which contains database connection information. Then,\u00a0 it will be passed to the Driver Manager and driver (ADO) directly. Beside that, The connection string need to be formatted as below form: Argument1=Value1; Argument2=Value2; Argument3=Value3;\u2026;ArgumentX=ValueX Example: Provider=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=SamplePassword; DBQ=C:\\Domains\\sample.net\\db\\sample.mdb; Please refer to the following article to know&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[54],"kbtag":[1292,1293],"class_list":["post-2203","kb","type-kb","status-publish","hentry","kbtopic-microsoft-access","kbtag-connection-string","kbtag-ms-access"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2203"}],"version-history":[{"count":5,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2203\/revisions"}],"predecessor-version":[{"id":6368,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2203\/revisions\/6368"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2203"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2203"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}