8 Methods to Overcome Access Error 2105 You Can’t Go to the Specified Record!

While handling Access databases, it is quite common to encounter errors. One such warning message that often perplexes users is- “runtime error 2105 you can’t go to the specified record.” This error typically appears when trying to create, open, or extract records in the Access database by running a VBA code or macros. In this blog, you will find the possible causes and methods to fix response code 2105 in Access in no time.

Here, you will also get the most reliable Access Repair Tool to fix this error if it has arisen due to DB file corruption.

What Is Error 2105 in Access VBA?

Generally, this error occurs while running the VBA code to access the database records. When this error occurs, it means that you can’t create or open the database record because the record has been deleted or does not exist.

On the other hand, we can say, this error appears when attempting to use a GoToRecord method. However, numerous factors can lead to docmd.gotorecord you can’t go to the specified record error. Here are the major ones:

1. Due to missing or damaged records.
2. Changing a primary key value of a record set.
3. Access database corruption
4. Mistakenly set the filter/sort to a form or report.
5. The source property of a record is invalid.
6. VBA code has an opened recordset and this has a lock on the record.

Is Data Loss Common with Microsoft Access Error 2105?

Yes, data loss is common with MS Access error 2105. If the error has occurred due to database file corruption and is not fixed promptly, it can cause data inconsistencies and severe data loss.

Note: Don’t forget to take regular backups to minimize this risk.

How to Fix Access Error 2105 You Can’t Go To The Specified Record?

Take a quick precape over the fixes to stop you can’t go to the specified record Access error.

Method 1- Do Minor Changes in the OnClick Event Code

If you are using the following OnClick Event code for your form button then you need to make little corrections in it.

DoCmd.GoToRecord , , acNext

Exit_Next_Record_Click:
Exit Sub

Err_Next_Record_Click:
select case err.number
case 2105
‘Msgbox “The record does not exist”
Beep
case else
MsgBox Err.Description
end select
Resume Exit_Next_Record_Click

End Sub

Corrections to be done:

doCmd.goToRecord record := acNewRec

in place of

doCmd.goToRecord record := acNewRecord

Method 2- Check the Property of ‘Record Source’

Sometimes, incorrect Record Source property can result in ‘you can’t go to the specified record Access error’. In order to solve this, you have to check the record source property settings by following the below steps:

• Open the Access >> open form in a design view.
• Under a Property Sheet, you have to click on a Data 
• After that, click on Record Source dropdown & ensure that record source property is pointing to the right table.

Also Read: Fix Run-Time Error 3047- Record Is Too Large Access?

Method 3- Try Redefining The Table to Fix Access Error 2105: You Can’t Go To The Specified Record

Redefining the table is the best-suited solution to fix Access error 2105. In this method, you need to remove all the unnecessary fields from your Access Table except the fields which are essentially important.

Method 4- Check the Settings of ‘Allow Filters’

many users have reported that they received Access response code 2105 due to improper ‘Allow Filters’ settings. To verify whether this setting is correct or not, you have to follow the below steps:

• First, open the Access database in the design view.
• Under a Property Sheet, you have to click on a Data 
• Here, ensure that the ‘Allow Filters’choice is set to the Yes.

Method 5- Use The Memo Fields

If you are using the text type fields for your keeping up your records then immediately switch to Memo type fields. For changing your text field type to memo the only thing that you need to do is assign the value “12” for the field type property.

In case, if the value is set to 10 then it means it’s a text field.

If you cross the limit of memo field then Visual Basic (VB) will use the individual pages for keeping fields in the database.

Method 6- Verify the Property of AllowAdditions

Another yet property you need to check to solve this error is-AllowAdditions. This property is mainly used to add the new records to a form/sub-form. However, when you attempt to add the records, you can receive error 2105.

In order to troubleshoot it, you can check the property of AllowAdditions. Follow the below steps to do this:

• Firstly, open the Access database in the design view.
• Under a Property Sheet, you have to click on a Format tab.
• Then, scroll down to locate the property “Allow Additions” & modify it to Yes.

After completion of these steps, now you will be able to access or add the records in a form.

Method 7- Fix MS Access Record Corruption

If you are unable to fix Access error code 2105 with the aforementioned methods, then it means that your Access records somehow got corrupted and you need to fix it by using Access Compact & Repair utility.

For severe database corruption, it is recommended to try reliable third-party software like Access Repair & Recovery to successfully repair corrupted Access Database. So what are you waiting for? Just download this, Access database repair tool and get your priceless Microsoft Access database records back.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Steps To Repair Corrupt Access Database

access-repair-main-screen

access-select-database

access-repairing

access-repairing-completed

access-preview

access-save-location

access-saving

Method 8- Seek Professional Support

In many cases, the cause of the error is unclear that’s why it is tough to overcome the situation. If you are also unable to identify the root of error 2105, you should immediately seek professional assistance. They can provide proficient guidance in resolving the problem effectively.

Related FAQs:

What Does Macro Single Step Error 2105 Mean?

Macro single-step error 2105 means that you can’t go to the specific record in Access.

How Often Does This Error Occur?

The frequency of occurrence of this error completely depends on factors like data volume, system complexity, and user activity.

Which Shortcut Key Is Used to Go to A Specific Record in Datasheet View?

Alt+F5 shortcut keys are used to go to a specific record in the datasheet view.

Can Outdated Software Cause This Error?

Yes, outdated Access software or mismatched system configurations can lead to this error.

How Do You Go to A Specific Record in Access Form?

To navigate to a specific record in the Access database, click on the arrow to the right of the Go to box, then choose a record from a drop-down list.

Can “You Can’t Go to the Specific Record Access Error” Be Fixed Without IT Support?

Yes, by applying the solutions provided in this blog, you can resolve this error without the need for IT assistance.

Also Read: Fix Run Time Error 3021: No Current Record Access

Wrap Up:

With the help of the above-mentioned methods, the docmd.gotorecord you can’t go to the specified record error can easily be resolved. If you are getting this error due to Access database corruption, use the recommended Access Repair tool. It will help you to repair and recover Access files in just a few clicks.

Good luck!

Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
2. Click Browse and Search option to locate corrupt Access database.
3. Click Repair button to repair & preview the database objects.

Pearson Willey

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.