Others

How to Fix Microsoft Access Error 2105 When Opening a New Record

Tauseeq Magsi Sep 30, 2026 868 views

Question details

Users encounter Error 2105 ('You cannot go to the specified record') when trying to open a new record in an Access form after migrating the database to a new server.

How to Fix Microsoft Access Error 2105 When Opening a New Record

Product: Microsoft Access
Device & OS: not provided
Scenario: A user triggers a form that uses VBA (DoCmd.GoToRecord , , acNewRec) to create a new record after the database has been moved to a new server.
Observed behavior: Access throws Error 2105, blocking the user from creating or navigating to a new record due to restricted user rights or folder permissions on the new server.

Before you start

Verify your current network access level and ensure you have the contact information for your IT administrator, as resolving this error typically requires administrative rights to modify folder permissions.

Solution 1Recommended

Verify and Correct Server Folder Permissions

Comparing and correcting network drive permissions is the most effective way to resolve Error 2105 after a server migration.

When an Access database is moved to a new server, users may inherit different permission levels. Microsoft Access requires Read, Write, and Modify permissions in the directory where the database resides to create the locking file (.laccdb) needed for adding new records.

Identify a working user account

Find a coworker or administrative account that can successfully open the form and add a new record without triggering Error 2105.

Compare network permissions

Right-click the network folder containing the database, select 'Properties', and navigate to the 'Security' tab to compare the permissions of the working user against the affected user.

Update permissions for the affected user

Have your IT administrator grant the affected user full Read, Write, and Modify permissions for the shared drive, folder, and database files.

Verify and Correct Server Folder Permissions

Permissions Applied: Once the permissions are corrected, the affected user should close and restart Microsoft Access to ensure the new network security policies take effect.

Solution 2

Implement a Split Database Architecture

Using separate local front-end copies for each user prevents locking conflicts and permission errors inherent in multiuser environments.

Free Microsoft Office alternative

Looking for a Reliable and Lightweight Office Suite?

While WPS Office does not include a database management tool like Microsoft Access, it serves as an excellent, free alternative for your daily document, spreadsheet, and presentation needs. Enjoy seamless compatibility and a familiar interface without heavy resource usage.

1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
2. Install and Launch: Run the installer, follow the on-screen instructions, and open the application to access Writer, Spreadsheets, and Presentation tools.
3. Open Your Files: Drag and drop your existing Microsoft Office files into the WPS workspace to continue working seamlessly.

Completely free and lightweight alternative to Microsoft OfficeHigh compatibility with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Familiar, tabbed user interface for effortless multitaskingBuilt-in PDF editing and conversion tools at no extra cost

microsoft office alternative - wps office

Frequently Asked Questions

What does the DoCmd.GoToRecord , , acNewRec command do in Access?

This VBA command instructs Microsoft Access to navigate to a new, blank record within the active form or table so the user can begin entering new data.

Why does Microsoft Access require folder write permissions just to view or add records?

When a user opens an Access database, the application creates a temporary locking file (.laccdb or .ldb) in the same folder to manage multiple users. If the user lacks write/modify permissions in that folder, Access cannot create this file, leading to operation failures and Error 2105.

What is a split Access database?

A split database separates the data tables (the back-end) from the application interface like forms, queries, and reports (the front-end). The back-end is stored on a shared network, while each user utilizes a local copy of the front-end, drastically improving stability and preventing network locking issues.

Office Quick Solutions