Error in Opening the DB

VKKT
2StarLounger
Posts: 184
Joined: 13 Jun 2018, 07:50

Error in Opening the DB

Post by VKKT »

Greetings!
Hope all are fine and safe.
I have an Access DB which was created in 2002 with 3/4 modules, reports and queries which has around 95000+105000+45000 records.
Since last few months I am facing some problem opening the DB, which gives some error messages as attached.

If I change the file name it will open, this is what I am doing for quite some time, which will work for 1 or 2 weeks, again the same problem will come.

Is there any other solution for this issue.

Regards,
VKKT
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78601
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Error in Opening the DB

Post by HansV »

This is a known problem that has been plaguing Access for quite a while now. See Access reports that databases are in an 'inconsistent state' for more information and a workaround.
Best wishes,
Hans

VKKT
2StarLounger
Posts: 184
Joined: 13 Jun 2018, 07:50

Re: Error in Opening the DB

Post by VKKT »

Greetings.

Thanks Mr. Hans for your response. There is no solution yet to this issue that is what I understood.

Regards,
VKKT

User avatar
HansV
Administrator
Posts: 78601
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Error in Opening the DB

Post by HansV »

Not a real solution, but the article does describe a workaround.
Best wishes,
Hans