What does Error 3112 indicate when compacting an MDB file?

What does Error 3112 indicate when compacting an MDB file?

The Error description is "Records can't b开发者_开发百科e read; no read permission on 'xyz123.mdb'"

There is a known issue with the Compact function on some versions of Access MDBs. Is the solution in this case to run the Microsoft utility JETCOMP.EXE on this file?

What are the other possible causes of this error?

This could well be a sign of corruption, I would suggest that you treat it like that for now and try doing a compact/repair and also a decompile and see if that snaps it out of it.

This is of course assuming that you do have permissions on the database, you might also want to check which workgroup file you are “joined” to at the moment in case the above does not work

I can't say the error pertains to any one issue I can think of. It possbile that some other routine or part of the applicaton is open and not closed.

I assume this error is occurring for only one application ?

Try creating a blank database file, and then import everything into that file. Does the compact and repair now work? This sounds more like a damaged or currupted file.