Compacting Back End Caused Some Front End Forms to Stop Working

[samjh]

Hi,

I have a split Database (2003) that has been working fine since it was installed in April, however for the first time the Back End was Compacted and Repaired today, which seemed to go fine, but when accessing the Front End one of the Search Forms had no data in it and people were unable to add new commitments. I took my master Front End and created a new MDE file from it and re-istalled this on everyones PC's and it now work fine again.

I have detailed what was done today below, but does anyone know why this would cause some of the Forms on my Front end to stop working, there were error messages appearing when people were trying to enter data.

Firstly Everyone was out of the Database
Took a copy of the file called Back End (so I now have Back End and Copy Back End in my file)
Compact and Repaired Copy Back End by opening Access, selecting Compact and Repair then selecting the Copy Back End file.
Re-named the Original Back End as Old Version Back End
Re-named the Copy that had been compacted as Back End (which is the name that the front end links to)

Any help on this would be great.
Thanks

 

[RainLover]

It appears you did everything right.

No need to convert a back end to mde. It really does add nothing. mde only affects code and there should be no or very little code in the back end.

The most important thing you did not do, because you swapped back ends is to relink your tables.

I would think the relinking was your problem.

Good to see you make a back up before compacting.

 

[samjh]

Hi, thanks for your very quick reply.

I didn't actualy do this it was someone from the company that supports our Database. We didn't think we would have to re-link the tables as effectively the Back End hadn't changed name and strangely some of the forms did work, and some didn't.

I didn't convert my back end to mde file, I only do this with my Front end when I create a new Front End to roll out.

 

[RainLover]

What you said makes sense.

However if relinking solved the problem then what you did is correct.