Recent content by swat

Thanks Micron! I'm pretty sure I tried the decompile (I was trying everything in the book) but I for sure will try that again the next time it happens.

Yes, the databases that encountered problems all had VBA code in them.

Hi theDBguy, The original issue was as follows: 1. User opens Access database and receives a corruption error. 2. I make a copy of the database and run a Compact and Repair and error goes away. 3. I ask several users to test the copy to make sure it's working. All works fine. 4. I delete the...

Thought I would post a final response from Microsoft after working with them rather extensively on this issue. There actually IS a known problem for this issue that Microsoft is working to resolve. I have attached 2 email correspondences that I had with Microsoft that explain 1) how to prevent...

Thought I would post a final response from Microsoft after working with them rather extensively on this issue. There actually IS a known problem for this issue that Microsoft is working to resolve. I have attached 2 email correspondences that I had with Microsoft that explain 1) how to prevent...

Thanks, everyone, for your continued comments. I am in the process of spitting the database with the intentions of giving each user their own front-end. I think we all agree that this is the best way to go and will most likely eliminate the corruption. I also wanted to let you know that I am...

Definitely agree and understood. However this would be an insurmountable task. We currently have 449 databases registered and upgraded and we are only half way through the upgrade process. These databases are developed by end users (some actually by inmates) and we currently have no control over...

We have a couple scenarios (the problem is affecting multiple databases). Scenario 1: The database is a single database and all users access that database on the network drive. Scenario 2: The database is a split database and all users access the single front-end on the network drive. I...

Thanks CJ! I'm sure the second option is not happening, but a very good point about decompiling the code. I have not yet done that. I know that I have done it before and have an explanation somewhere. But would you happen to have instructions on how to do that? It's a command line statement, is...

Interesting idea. But, yes, the ldb does not exist when I perform the rename and copy. Thanks for thinking of it.

I posted this same issue back in 2014 and never found a definite solution. I am working with a government agency that uses hundreds of Access databases. We are upgrading from Windows 7 to Windows 10 as well as Office 2010 to Office 2013. It appears that the problem has resurfaced with users...

I do have admin rights on my workstation so you might have the idea. I'll give it a try.

Thanks, llkhoutx. Yes, I have been able to copy, create new, etc. but whenever I name the database with the original database name only those two users continue to get the error. So I can't even put a repaired database back in the network folder with the correct production name.

I have a split Access 2010 database on a network with only 2 users. Recently they received the dreaded error "The document xxx caused a serious error the last time it was opened. Would you like to continue opening it?" Both users continued to get the error and each time Access created a Backup...

Thanks again, SOS. I did read your article as well as the additional article links and must admit that they are an interesting twist and explanation to why split databases are beneficial. I usually create my own databases in split format and may just recommend that they do the same. However I...