Results 1 to 6 of 6

Thread: Pastel Partner 50c Database Editor

  1. #1
    New Member
    Join Date
    May 2016
    Location
    KZN
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner 50c Database Editor

    Morning all.

    In older versions of Pastel I could view and edit the database directly to fix small errors. However, 50c does not come with a database editor....any idea what program I can use?

    The error is small and I'm certain I can repair it a lot faster than Pastel support says it will take to do if I send them the files, just cant not process anything for the 2 days they say it will take to fix.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,781
    Thanks
    44
    Thanked 452 Times in 397 Posts
    You can use the Pervasive Control Centre to access the database.

    I often use a small, rather outdated, betrieve database editor called bdbd32 - you can download it from here: Bdbd32

    Save the folder in the Pastel19 folder.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    New Member
    Join Date
    May 2016
    Location
    KZN
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville!

  4. #4
    Junior Member
    Join Date
    Apr 2021
    Location
    south africa
    Posts
    17
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Hi Neville.

    Would it be possible to edit an inventory code with that? My OCD is kills me everytime I look at it and would like to be able to fix it.

    Thanks.

  5. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,781
    Thanks
    44
    Thanked 452 Times in 397 Posts
    Quote Originally Posted by BikerBob View Post
    Hi Neville.

    Would it be possible to edit an inventory code with that? My OCD is kills me everytime I look at it and would like to be able to fix it.

    Thanks.
    I would not use the database editor to edit inventory codes, as there are multiple records in multiple data tables that are linked to an inventory code, and unless you have the time and knowledge to edit everything that is connected, you could very well "break" the database.

    If you have Partner, rather use the Change...Renumber Codes option.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  6. #6
    Junior Member
    Join Date
    Apr 2021
    Location
    south africa
    Posts
    17
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Thanks Neville. I'll leave it alone.

Similar Threads

  1. "Accounting Periods" Database Table in Sage Pastel Partner v19
    By michellepace in forum Accounting Forum
    Replies: 2
    Last Post: 10-Sep-19, 06:17 AM
  2. [Question] How to fix corrupted Pastel Partner database
    By George Chakawata in forum Accounting Forum
    Replies: 0
    Last Post: 25-Jan-18, 03:03 PM
  3. Pastel Partner Database - Pervasive
    By Riandwelm in forum Accounting Forum
    Replies: 1
    Last Post: 29-Mar-17, 03:22 PM
  4. [Question] issue in pastel database
    By Danyal in forum Accounting Forum
    Replies: 0
    Last Post: 12-Apr-15, 07:55 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •