How to Resolve Tally Prime Error Code 32: Data File Locked

Running a business on Tally Prime requires continuous database write access for recording bills, vouchers, and transactions. A common technical issue in multi-user environments is **Error Code 32: Data file is locked by another process**.

This error blocks user operations and indicates that another Windows application is holding a write-lock on Tally's active files. Let's look at how to identify the cause of this error and resolve it step-by-step.

1. What Triggers Error Code 32?

Tally Prime stores transaction details in proprietary relational database files (such as `.tsf`, `.900`, or `.1800` formats). When Tally writes data, it requests an exclusive lock from Windows. If another program is accessing these files, Windows denies the lock, triggering Error 32.

Common programs that cause these file-locks include:

• Cloud Backup Tools: Services like Microsoft OneDrive, Google Drive, and Dropbox that attempt to sync files the moment they are modified.
• Antivirus Real-Time Protection: Scanners checking database modifications for malware.
• Windows Permission Blocks: Restricted folder access rules that prevent standard users from writing data.

2. Step-by-Step Troubleshooting Guide

Apply these configurations in order to resolve the lockups:

Solution 1: Disable Real-Time Cloud Sync on Data Folders

If your Tally data directory is stored inside the Windows Desktop, Documents, or default OneDrive paths, move the data to a local path (such as `C:\TallyData\Company_10000`). Configure OneDrive or Google Drive settings to exclude this directory from real-time sync.

Solution 2: Configure Antivirus Scan Exclusions

To prevent real-time antivirus scans from locking Tally database files:

1. Open your Antivirus Security Center (e.g., Windows Defender Security).
2. Navigate to **Virus & Threat Protection Settings > Manage Settings > Exclusions**.
3. Select **Add or Remove Exclusions > Add Folder** and select your active Tally data path.
4. Add the Tally installation directory and the executable files (`tally.exe` and `tallygatewayserver.exe`) to the exclusions list. Save settings.

Solution 3: Modify Windows Folder Write Permissions

Ensure your Windows users have write permissions on the data folder:

1. Right-click the Tally data directory and select **Properties**.
2. In the **Security** tab, select the active user profile or group and click **Edit**.
3. Set permissions for **Full Control**, **Read**, and **Write** to **Allow**. Click Apply and OK.

3. Multi-User Network Considerations

In multi-user LAN networks, ensuring database stability requires:

• Using wired connections (Ethernet CAT-6 cables) instead of Wi-Fi for all workstations to prevent packet loss.
• Assigning static local IP addresses and ports to the Tally Gateway Server host.