{"id":892,"date":"2012-06-05T08:53:54","date_gmt":"2012-06-05T08:53:54","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=892"},"modified":"2025-05-28T06:14:01","modified_gmt":"2025-05-28T06:14:01","slug":"database-profiles-table-error-on-sage-300-workstation","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/","title":{"rendered":"Database Profiles table error on Sage 300 Workstation"},"content":{"rendered":"

You come across Database profiles table error while opening the database Setup utility on a Sage (Accpac) 300 ERP workstation. It may persist even after you assign all Read\\Write rights to the system and windows user on Sage Accpac folder in installation directory.
\n\"\"<\/a>
\nThis type of error occurs due to invalid path of Programs and Shared data while installing Accpac Workstation on another machine. Suppose we have installed Sage Accpac Server on one system having IP as 192.168.0.56 with installation directory path for Sage Accpac as
\nPrograms \u00a0\u00a0\u00a0\u00a0 \u00a0C:\\Program Files\\Sage\\Sage Accpac6.0
\nShared data\u00a0\u00a0 C:\\Program Files\\Sage\\Sage Accpac6.0\\Data
\nSubsequently, we assign necessary rights to user of the workstation machine from the server where Sage Accpac in installed, as shown in the screenshot below.
\n\"\"<\/a>
\nUsually, we consider this type of issue is due to inadequate rights and that\u2019s correct. However there may be some other cause ahead of this which can result in the above error. You may follow the below procedure to overcome this.
\n1. As mentioned above, firstly cross check if rights have been assigned on Sage Accpac Server machine to the windows user where Sage Accpac workstation has been installed (refer the above screen shot).
\n2. Then, on the workstation machine<\/strong> go to Start>>Run>>Type \u2018regedit\u2019 and press enter. A registry editor screen will be opened.
\n3. In registry Editor Page Go to My Computer >> HKEY_LOCAL_MACHINE >> Software>> Accpac International, Inc >> Accpac >> Configuration.
\n\"\"<\/a>
\nAs in above screenshot, the path for Shared data is given as \u2018\\\\192.168.0.56\\Sage Accpac 6.0\u2019 wherein 192.168.0.56 is the IP of Accpac Server machine and rest is shared directory of Sage Accpac on Sage Accpac Server machine. But on Sage Accpac Server machine, we had put the directory path as \u2018Sage Accpac6.0\\Data\u2019 which is different from the path mentioned in the above screenshot.
\n4. Now click on Highlighted Shared data. It will show you certain options. You may select \u2018Modify\u2019 option to make the changes.
\n5. Once we click on \u2018Modify\u2019 the Edit String screen will appear. It will allow you to change the path of the Shared Data in Value Data Field. Now put the path as given in below screenshot.
\n\"\"<\/a>
\n6.\u00a0After following the above steps, Go to Start menu and open Sage Accpac>>database Setup. Now the Sage Accpac database setup screen should open without any issue.
\nIn this way, we can operate Database Setup on Sage (Accpac) 300 ERP workstation.<\/p>\n","protected":false},"excerpt":{"rendered":"

You come across Database profiles table error while opening the database Setup utility on a Sage (Accpac) 300 ERP workstation. It may persist even after you assign all Read\\Write rights to the system and windows user on Sage Accpac folder in installation directory. This type of error occurs due to invalid path of Programs and\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[704,891],"class_list":["post-892","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-database","tag-error"],"yoast_head":"\nDatabase Profiles table error on Sage 300 Workstation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Profiles table error on Sage 300 Workstation\" \/>\n<meta property=\"og:description\" content=\"You come across Database profiles table error while opening the database Setup utility on a Sage (Accpac) 300 ERP workstation. It may persist even after you assign all ReadWrite rights to the system and windows user on Sage Accpac folder in installation directory. This type of error occurs due to invalid path of Programs and\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-05T08:53:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-28T06:14:01+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/\",\"name\":\"Database Profiles table error on Sage 300 Workstation\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg\",\"datePublished\":\"2012-06-05T08:53:54+00:00\",\"dateModified\":\"2025-05-28T06:14:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Profiles table error on Sage 300 Workstation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Profiles table error on Sage 300 Workstation","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:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/","og_locale":"en_US","og_type":"article","og_title":"Database Profiles table error on Sage 300 Workstation","og_description":"You come across Database profiles table error while opening the database Setup utility on a Sage (Accpac) 300 ERP workstation. It may persist even after you assign all ReadWrite rights to the system and windows user on Sage Accpac folder in installation directory. This type of error occurs due to invalid path of Programs and\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2012-06-05T08:53:54+00:00","article_modified_time":"2025-05-28T06:14:01+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/","name":"Database Profiles table error on Sage 300 Workstation","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg","datePublished":"2012-06-05T08:53:54+00:00","dateModified":"2025-05-28T06:14:01+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/06\/013.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/06\/05\/database-profiles-table-error-on-sage-300-workstation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Database Profiles table error on Sage 300 Workstation"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=892"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/892\/revisions"}],"predecessor-version":[{"id":35424,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/892\/revisions\/35424"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}