{"id":24317,"date":"2022-02-02T14:30:23","date_gmt":"2022-02-02T14:30:23","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/"},"modified":"2023-10-19T13:00:12","modified_gmt":"2023-10-19T13:00:12","slug":"plesk-how-to-configure-accdb-db-for-odbc-connections","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/","title":{"rendered":"Plesk: How to configure accdb DB for ODBC connections"},"content":{"rendered":"<p><span style=\"font-family: Helvetica, sans-serif;\">This article provides you with information on how to configure your ODBC connections on Windows Plesk.<\/span><\/p>\n<p><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/p>\n<p><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/p>\n<div style=\"box-sizing: border-box; font-family: 'Segoe UI', system-ui, 'Apple Color Emoji', 'Segoe UI Emoji', sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><span style=\"font-family: Helvetica,sans-serif;\"><span style=\"font-size: 14px;\">With the Plesk control panel ODBC connections with accdb database are not supported, \u00a0it has to be mdb database.<\/span><\/span><\/div>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Below please find the instructions on how to convert accdb to mdb for Plesk.<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\"><strong>Convert a .accdb database to an earlier file format<\/strong><\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Do the following to create a copy of an Access database in a file format that you specify.<\/span><\/span><\/p>\n<ul>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">First, open your database:<\/span><\/span><\/li>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Click the File tab.<\/span><\/span><\/li>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">On the left, click Open.<\/span><\/span><\/li>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">In the Open dialog box, select and open the database that you want to convert.<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Now, convert your database:<\/span><\/span><\/p>\n<ul>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Click the File tab.<\/span><\/span><\/li>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">Under File Types, click Save Database As. Under Save Database As, do one of the following:<\/span><\/span>\n<ul>\n<li style=\"margin-left: 20px;\"><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">To save a copy of the database in a .mdb format that can be opened by using Access 2002 or Access 2003, click Access 2002 &#8211; 2003 Database (*.mdb).<\/span><\/span><\/li>\n<li style=\"margin-left: 20px;\"><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">To save a copy of the database in a .mdb format that can be opened by using Access 2000, click Access 2000 Database (*.mdb).<\/span><\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-bordered\" style=\"width: auto;\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33050252611\/original\/UOt-3r88xShVH5cE55Q_iNmyChs2KN-xSQ.png?1606380119\" data-attachment=\"[object Object]\" data-id=\"33050252611\" \/><\/span><\/span><\/p>\n<ul>\n<li><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">In the Save As dialog box, in the File name box, type a name for the database file, and then click Save.<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 14px;\"><span style=\"font-family: Helvetica,sans-serif;\">\u00a0<\/span><\/span><\/p>\n<p><span style=\"font-family: Helvetica, sans-serif;\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article provides you with information on how to configure your ODBC connections on Windows Plesk. \u00a0 \u00a0 With the Plesk control panel ODBC connections with accdb database are not supported, \u00a0it has to be mdb database. \u00a0 Below please find the instructions on how to convert accdb to mdb&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1199],"ht-kb-tag":[1267,219,224,270,470,480,684,747],"class_list":["post-24317","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-plesk","ht_kb_tag-accdb","ht_kb_tag-configure","ht_kb_tag-connection","ht_kb_tag-database","ht_kb_tag-hosting","ht_kb_tag-how-to","ht_kb_tag-odbc","ht_kb_tag-plesk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Plesk: How To Configure Accdb Db For Odbc Connections<\/title>\n<meta name=\"description\" content=\"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plesk: How To Configure Accdb Db For Odbc Connections\" \/>\n<meta property=\"og:description\" content=\"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-19T13:00:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33050252611\/original\/UOt-3r88xShVH5cE55Q_iNmyChs2KN-xSQ.png?1606380119\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/\",\"name\":\"Plesk: How To Configure Accdb Db For Odbc Connections\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:30:23+00:00\",\"dateModified\":\"2023-10-19T13:00:12+00:00\",\"description\":\"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plesk: How to configure accdb DB for ODBC connections\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plesk: How To Configure Accdb Db For Odbc Connections","description":"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/","og_locale":"en_US","og_type":"article","og_title":"Plesk: How To Configure Accdb Db For Odbc Connections","og_description":"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base","og_url":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2023-10-19T13:00:12+00:00","og_image":[{"url":"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33050252611\/original\/UOt-3r88xShVH5cE55Q_iNmyChs2KN-xSQ.png?1606380119"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/","url":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/","name":"Plesk: How To Configure Accdb Db For Odbc Connections","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:30:23+00:00","dateModified":"2023-10-19T13:00:12+00:00","description":"Configure ACCDB Database for ODBC Connections effortlessly with our guide: 1-grid Knowledge Base","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/plesk-how-to-configure-accdb-db-for-odbc-connections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Plesk: How to configure accdb DB for ODBC connections"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24317"}],"version-history":[{"count":1,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24317\/revisions"}],"predecessor-version":[{"id":29462,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24317\/revisions\/29462"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24317"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24317"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}