Hi Twinnyfo
Thanks for your message.
Food for thought! I would certainly like everything to be at the same revision level. It used to be in 'the old days' but with Microsoft Updates to Access and the OS, its difficult to know. Were you impacted by the 'Query is Corrupt' fiasco caused by a Security Update in Oct 2019?
https://support.microso ft.com/en-us/office/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f216...
Tango1
Last Activity: Nov 28 '23, 05:35 PM
Joined: Oct 28 '20
Location:
-
Thank you both for your comments. I know how much time it consumes.
I can find very little information on lock files. It looks as though I'm going to have to resurrect some old kit and set myself a multi-user system with different versions of Access. I'll post any useful results.
Coincidentally, another legacy Access application (not mine) in a different branch of the same client has started to break similarly, although...Leave a comment:
-
Thanks for your sympathetic response Ade (I would have posted on UKAUG but am no longer a member)
Perhaps I wasn't clear (trying to keep brief). I made the changes AFTER the issue arose because having browsed for the issue I came up with the following statement from Microsoft about databases in an inconsistent state.
https://support.microso ft.com/en-us/office/access-reports-that-databases-are-in-an-inconsistent-stat...Leave a comment:
-
Incompatibilities between Access 2016 and O365 lock files ?
Hi Guys
One of my clients is still having problem with an Access system breaking a couple of times a day with an 'Unrecognized database format' error.
I posted back in November suspecting it was an intermittent network causing the problem. Previously the app had been running without problems for more than 10 years. The backend is hosted on a server in the IT dept. It seems that most of the time there are only two users; the... -
Hi Guys
Thanks for your help so far but I fear we have an unsolvable issue here, probably caused by Microsoft Updates. Will probably need to rename this thread!
My user finally sent a screen shot of the error message and it was "Unrecognis ed Database format" . An internet search shows many other instances of this problem and Microsoft have suggested a registry hack on the server, to DisableLeasing.
https://...Leave a comment:
-
Yes, the BE seems to go into an unresponsive state which can be fixed by a Comp & Repair.
I'm going to pursue the suggestion to export the BE to a clean database in case there is something like an index that is not being properly rebuilt by a C&R.
I'm also trying to get a better description of the error rather than "it's something like the database is not available".
I'm also going to...Leave a comment:
-
Hi Jim. Thanks for your reply.
The main user is in a laboratory and has the system open all day. He finds the system has broken after entering a item-number and gets the message "database is not available" when trying to retrieve details of that item. (I'm trying to illicit the exact wording.)
Failure is not isolated to just one form but seems can occur at any time an enquiry is made i.e. listings by equipment type...Leave a comment:
-
I agree with your first statement isladogs, a decompile is usually required to fix most errors. However, in this instance a C&R on the BE fixes the problem (there is no 'code' in the BE so nothing to decompile) but does nothing for the FE.
I did request the User to re-install the FE from the distribution copy, so should be clean and not require a decompile. I'll check today that he did this and also the exact wording of the error....Leave a comment:
-
twinnyfo and SwissProgrammer thank you both for your detailed responses. You were both err-ing on the side of bad hardware or corrupted code and I would pursue these if I could. However, the client is an 'international' and difficult enough to get through the front door in normal circumstances.. ...
The BE is on a server in their datacentre. Two things I could possibly do is have them convert it from an MDB to a ACCDDB hoping that is...Leave a comment:
-
Logging break in connection to Back-End
An Access system of 10 years vintage is starting to give 'corrupt database' errors. I've written a mini-app to allow the User to run Compact and Repair operations on both the FE and BE databases which allows him re-start working.
I've attributed the problem to the IT department 'doing some work on the network' but the problem (intermittent, say 1-2 time a week) seems to be ongoing.
I'm thinking of writing a mini-app...
No activity results to display
Leave a comment: