By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,658 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,658 IT Pros & Developers. It's quick & easy.

Please Help

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 <me@privacy.com> 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.

Nov 13 '05 #2

P: n/a
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 <me@privacy.com> 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.

Nov 13 '05 #3

P: n/a
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 <me@privacy.com> 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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.