Please Help

[Enterprise]

I use MS ACCESS front end back end design. Multiple computers. There
is a form that uses a table for calculation purposes. When ever the
table is open on one computer, the form does not work anywhere else(MS
access freezes). When the table is closed, MS Access unfreezes and the
form works. I'm not sure how to fix this.

Thanks

[Enterprise]

I have a frond end back end. The table has to be shared inbetween
users since the users update it from time to time. So I guess I have
to find a way to make a snapshot of the table each time the user wants
to view it...

MGFoster <[e-mail]> wrote in message news:<CF**************@newsread1.news.pas.earthlin k.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It sounds as if you don't have the front-end on each user's PC. Also,
if the table is used by each user to complete the calculation, then that
table should be a local table. IOW, it should be in each user's front
end.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMjG8YechKqOuFEgEQKIkgCgmBynb4uxNcP7v0hxqWzZzE dip/4AoJdz
RnJJMXzUbFbXXjNLAZ174YxK
=oo2x
-----END PGP SIGNATURE-----
Enterprise wrote:

I use MS ACCESS front end back end design. Multiple computers. There
is a form that uses a table for calculation purposes. When ever the
table is open on one computer, the form does not work anywhere else(MS
access freezes). When the table is closed, MS Access unfreezes and the
form works. I'm not sure how to fix this.

[Galina]

Hello
I doubt that it is correct. My users view background table including
calculated fields, they edit data (including calculations) and all
these actions do not cause any freezing. I think the problem is with
network. "Enterprise", what network do you use?
Regards.
Galina
MGFoster <[e-mail]> wrote in message news:<CF**************@newsread1.news.pas.earthlin k.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It sounds as if you don't have the front-end on each user's PC. Also,
if the table is used by each user to complete the calculation, then that
table should be a local table. IOW, it should be in each user's front
end.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMjG8YechKqOuFEgEQKIkgCgmBynb4uxNcP7v0hxqWzZzE dip/4AoJdz
RnJJMXzUbFbXXjNLAZ174YxK
=oo2x
-----END PGP SIGNATURE-----
Enterprise wrote:

I use MS ACCESS front end back end design. Multiple computers. There
is a form that uses a table for calculation purposes. When ever the
table is open on one computer, the form does not work anywhere else(MS
access freezes). When the table is closed, MS Access unfreezes and the
form works. I'm not sure how to fix this.

[Enterprise]

The office uses Windows 200 Server...

ga****@mail.ru (Galina) wrote in message news:<ec*************************@posting.google.c om>...

Hello
I doubt that it is correct. My users view background table including
calculated fields, they edit data (including calculations) and all
these actions do not cause any freezing. I think the problem is with
network. "Enterprise", what network do you use?
Regards.
Galina
MGFoster <[e-mail]> wrote in message news:<CF**************@newsread1.news.pas.earthlin k.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It sounds as if you don't have the front-end on each user's PC. Also,
if the table is used by each user to complete the calculation, then that
table should be a local table. IOW, it should be in each user's front
end.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMjG8YechKqOuFEgEQKIkgCgmBynb4uxNcP7v0hxqWzZzE dip/4AoJdz
RnJJMXzUbFbXXjNLAZ174YxK
=oo2x
-----END PGP SIGNATURE-----
Enterprise wrote:

I use MS ACCESS front end back end design. Multiple computers. There
is a form that uses a table for calculation purposes. When ever the
table is open on one computer, the form does not work anywhere else(MS
access freezes). When the table is closed, MS Access unfreezes and the
form works. I'm not sure how to fix this.