{"id":280,"date":"2021-03-24T11:42:15","date_gmt":"2021-03-24T11:42:15","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=280"},"modified":"2021-10-26T12:23:34","modified_gmt":"2021-10-26T11:23:34","slug":"db4sql-at-ahs","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/sql\/db4sql-at-ahs\/","title":{"rendered":"DB4SQL at AHS"},"content":{"rendered":"<p>The DB4SQL program is not installed on each computer.<\/p>\n<p>This would be ideal, but it takes considerable time to install and keep updated.<\/p>\n<p>Instead a Portable version has been saved on the network &#8211; which any computer can run.<\/p>\n<p>However, your computer does not know where the program is.<\/p>\n<h1>Option 1 &#8211; Shortcuts<\/h1>\n<p>If you do not already have a shortcut to DB4SQL :<\/p>\n<ul>\n<li>Open Windows Explorer (win+E)<\/li>\n<li>Open N:\\Computing\\Database Browser for SQLite<\/li>\n<li>Right-click the .exe file and select &#8220;Pin to Start&#8221;<br \/>\n<em>if this doesn&#8217;t work, then copy the shortcut to your database folder<\/em><\/li>\n<\/ul>\n<h1>Option 2 &#8211; Registering DB4SQL<\/h1>\n<p><em>This option takes a few more steps, but will register the application on your computer. You will then be able to open database files by double-clicking them.<\/em><\/p>\n<ul>\n<li>Right-click on a database (*.db) file<\/li>\n<li>Select Properties<\/li>\n<li>Click the Change button<\/li>\n<li>Click &#8220;More apps&#8221;<\/li>\n<li>Scroll down to bottom of list<\/li>\n<li>Click &#8220;Look for another app on this PC&#8221;<\/li>\n<li>Open folder &#8220;N:\\Computing\\Database Browser for SQLite&#8221;<\/li>\n<li>Select &#8220;SQLiteDatabaseBrowserPortable.exe&#8221;<\/li>\n<li>Press &#8220;Open&#8221; button<\/li>\n<li>Press &#8220;OK button&#8221;<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The DB4SQL program is not installed on each computer. This would be ideal, but it takes considerable time to install and keep updated. Instead a Portable version has been saved on the network &#8211; which any computer can run. However, your computer does not know where the program is. Option 1 &#8211; Shortcuts If you do not already have a shortcut to DB4SQL : Open Windows Explorer (win+E) Open N:\\Computing\\Database<\/p>\n<p><a class=\"more-link\" href=\"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/sql\/db4sql-at-ahs\/\">Read More<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":9,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-280","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=280"}],"version-history":[{"count":4,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/280\/revisions"}],"predecessor-version":[{"id":414,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/280\/revisions\/414"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/9"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}