Saturday, 23 December 2017

How To Fix “MS Access is Not Responding “Error In Access 2010/2013/2016?



Practical scenario:
 Few days back when I am using Access 2013 application. My form contains a big query and it work just fine but when I click the mouse anywhere inside the form the message “Access Not Responding” appears in top line with program name and the system halt.
 I struggling a lot with this error, if anyone having solution to resolve this then do share it with me. I am stucked with this.

Tuesday, 19 December 2017

Fix [Microsoft][ODBC Microsoft Access Driver] Cannot Update. Database Or Object Is Read-Only Error


Practical Scenario:

This regards an Access 2010 accdb with a SQL Server back end: This front end is using a linked view to enter or update data (using INSTEAD OF trigger). The problem is that every so often it gives the "Cannot update. Database or object is read-only" error when trying to enter or update data through this view. The only thing that fixes this issue is deleting the linked view, re-linking it and setting the primary key again. However, this fix doesn't last; the problem usually shows up again the next day and has to be fixed again.

Fixes To Resolve MS Access “Not A Valid Bookmark” Error



Scenario:

Hey friends…!
 Few days back when I tried to open the Access Database, I receive the following error message "Not a Valid Bookmark" and all of a sudden my database denies opening. I have tried Compact and Repair but it won’t help me in resolving this error. I created new DB and tried to import from corrupted DB but still got the same error message. I tried accessing the DB using access and ms query and still won’t get any success. 

Tuesday, 12 December 2017

3 Top Ways To Prevent Your Access Database From Being Corrupt

Are you afraid that your MS access database get corrupt or damage like any other system file? Well it’s obvious to get afraid off because when this happen, you are unable to access the database (ACCDB and MDB) files, thereby obstacle you to stop your vital project work. In such situation, the only thing you need to do is repair the ACCDB and MDB files. 

How To Fix Access Run Time Error 13 - Type Mismatch Error


Want to know what fixes are there to solve Run-time error ‘13’: Type mismatch error? Well for the solution you need to read the complete post.  So just stuck till the end….! Start with the practical scenario that is encountered by one of the users like you only.

Monday, 11 December 2017

How To Resolve Access Missing Fields In A Crosstab Query Issue


One very common issue with which most Access users commonly encountered is with creating a crosstab queries. Mainly the problem is that in the crosstab query, a column will only be displayed if there is a data for that group; if there is no data, the column is not displayed.

Thursday, 7 December 2017

Fixes To Resolve Access 3047 “Record Is Too Large” Error



Does your access database frequently encountering the error “record is too large”? If yes then just follow the workarounds needed to fix this Access Runtime Error 3047.