Run-time error 3021

SOLVED

I receive an error message when I launch my POS software, making me unable to work on the software. The error message is:

Run-time '3021', 

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

  • +1
    verified answer

    Dear Akin,

    The error is caused by the Documents.mdb file being corrupt. Please try to compact the database to see if it clears the error in POS. To compact the databases follow the steps below:

    1. Make a backup of your current data through Pastel Partner and ensure all users have close both Partner and Point of Sale.
    2. Open Point of Sale and go to File…Open
    3. Double click on your company folder and click on Compact Database as shown below:

     

    If the data is not compacted successfully, you can try to compact the database using Microsoft Access. To compact database using Microsoft Access please follow the steps below:

    1. Make a backup of your current data through Pastel Partner and ensure all users have close both Partner and Point of Sale.
    2. Open the file Documents.Mdb located in your company folder.
    3. Click the Microsoft Office Button, point to Manage, and then, under Manage this database, click Compact and Repair Database.

    If you cannot compact the database using the above methods. You have two options as listed below:

    1. To replace the file with one from an old backup. This means you will not be able to reprint invoices from Point of Sale. However, you can print these in Sage 50c Pastel Partner or Xpress if they were updated already. If there were any transactions e.g. invoices that were processed in POS and were not updated, you need to reprocess them.

    2.     To restore the whole backup and reprocess all the transactions done in Partner and POS since the backup was done.

    Hope this helps in resolving your query.

    Regards,

    Mapule.

  • 0 in reply to Mapule

    Thank you Mapule