{"id":334,"date":"2019-08-12T13:33:08","date_gmt":"2019-08-12T12:33:08","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=334"},"modified":"2019-08-12T13:33:08","modified_gmt":"2019-08-12T12:33:08","slug":"connecting-visual-studio-to-microsoft-access","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/programming\/asp-net\/connecting-visual-studio-to-microsoft-access\/","title":{"rendered":"Connecting Visual Studio to Microsoft Access"},"content":{"rendered":"\n

Start by running the following file:

C:\\Windows\\SysWOW64\\odbcad32.exe<\/p>\n\n\n\n

You will then need to create a user DSN:<\/p>\n\n\n\n

Within the ‘ODBC Data Source Administrator’ window, ensure that the ‘User DSN’ is selected, then click the ‘Add’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

A new window will appear titled ‘Create New Data Source’. Ensure that the ‘Microsoft Access Driver (*.mdb)’ option is selected, then click the ‘Finish’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

Afterwards, a window titled ‘ODBC Microsoft Access Setup’ will appear. In the ‘Data Source Name:’ field, give your data source a name then click the ‘Select’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

After that, a window titled ‘Select Database’ will appear. Locate your Microsoft Access database, then click the ‘OK’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

Return to Visual Studio and set up a data connection using your ODBC data source.<\/p>\n\n\n\n

Within the ‘Server Explorer’ pane (left hand side of screen), right-click ‘Data Connections’, then click ‘Add Connection…’\n\n<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

A new window will appear titled ‘Choose Data Source’. Ensure that the ‘Microsoft ODBC Data Source’ option is selected, then click the ‘Continue’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n

Afterwards, a window will appear titled ‘Add Connection’. Within the ‘Data source specification’ section, ensure that the ‘Use user or system data source name:’ option is selected, choose your data source name from the drop down list (if you don’t see it within the drop down list, click the ‘Refresh’ button), then click the ‘OK’ button<\/p>\n\n\n\n

\"Screenshot:<\/figure>\n\n\n\n


<\/p>\n","protected":false},"excerpt":{"rendered":"

Start by running the following file: C:\\Windows\\SysWOW64\\odbcad32.exe You will then need to create a user DSN: Within the ‘ODBC Data Source Administrator’ window, ensure that the ‘User DSN’ is selected, then click the ‘Add’ button …<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":49,"menu_order":9,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-334","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/334\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/49"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}