FE & BE and .MDW Files

[jeff_i]

Simple Question: Should both the backend tables and the FE use the same MDW file?

I have currently have a database with about 35 users, max of 10 concurrent, I am creating a new front end with added security, so I have created a new workgroup information file.

I tested the new FE, with a sample backend and everything worked fine. Then I gave 1 person the new front end and I started getting a corrupted backend. (The application has run for since 8/24/02 with no corruptions until now), needless to say I removed the new FE and went back to the old one. I am not sure if the two are related yet. But since I was only giving the new FE to one person I did not change the security on the BE. Could this have caused my problem??

Thanks for any advice.

 

[ghudson]

I have never heard of anybody using a different MDW file for the front end and back end.

I personally use the same Secured.mdw file for the front end and back end. The Secured.mdw file is on the users computer in the same location as the front end. Each time the front end is updated, the users get the new version as well as the updated Secured.mdw file.

HTH

 

[jeff_i]

ghudson

Thanks for the reply, what your saying makes. I am wondering if what I did is the cause of the problems or if it is just a coincidences