Database breaking

[jj1]

• Some users of an ACCDE file get this error message:
  
  
  "The database cannot be opened because the VBA project contained in it cannot be read."
  
  Here are the details of what I'm doing:
  1. I Make ACCDE from MS Access 2010
  2. I put ACCDE on the network
  3. Users try to load the ACCDE.
  4. Some users are successful.
  5. Some users get this message:
  "The database cannot be opened because the VBA project contained in it cannot be read."
  
  All users have the same install procedure:
  1. Project Referenced DLLs
  2. MS Access 2010 Runtime
  
  Notes:
  1. The ACCDB file opens and runs properly in Access Development Environment.
  2. The ACCDE worked at some point on the user's machine that is now not working.
  3. Some of the previous versions now do not work either.
  4. We have tried decompiling , compact and repair, and starting a new DB and copying the objects in.
  
  Please provide help on the above.

[June7]

Don't know that this will solve the issue but each user should run their own copy of the frontend located on their workstation.

[jj1]

That is not possible I have 400 customers and single person supporting database. Do you have anyother solution

[ranman256]

Is it possible NOT to use ACCDE.... Just use the accdb?

[jj1]

Hmm That's what I was upto for now till I get Longterm solution

[June7]

This is not a split design?

400 users! - everything I read says corruption is inevitable when using a shared file, split or not. Review https://www.accessforums.net/code-re...end-33331.html