Why does front end get corrupted.

[P_Henry]

Hi,

The front end of the system that I have implemented recently gets corrupted frequently when the back end remains fine.
I am new to Access and I am not able to understand why this should happen.
The front end has reports, forms, queries, linked tables from the back end and related VBA code.
Any help will be use ful.

Thanks,...

 

[pbaldy]

One common cause is multiple users accessing the same copy of the front end at the same time. Is that the case here?

 

[P_Henry]

Yes Paul...The front end resides on the network and they all use the same front end..

 

[pbaldy]

That's likely your problem then. The "accepted" setup is to have copies of the front end on each client PC. There are ways to automate the distribution of new versions, if you search here.

 

[P_Henry]

Dear Pat and Paul,

Thanks..I will try this option