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

Need help with multi-user environment

P: n/a
Ok, so I've set up a database over a LAN and got it working. I split
the FE and the BE and I have the client computer accessing the BE on
the host computer. I figured out how to set the refresh rate so that
the FEs update themselves (I set it to 5 seconds for right now). The
databases refresh fine, my problem is, the FE on one computer doesn't
actually save changes to a record it has editted until you quit Access.
Here's an example of what I mean: Both computers are viewing the same
tables from the BE on the host computer. The client computer changes a
single record. The host computer keeps refreshing every five seconds
but the change doesn't show up. But if I exit MS Access on the client
computer (the one that changed the record), the change shows up in
exactly five seconds on the host computer. Why does access only REALLY
save the record after you exit the database? Even if I hit the save
button the change doesn't show up until I exit.

Thanks for any help,
-Robert

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 3 Jun 2005 12:38:09 -0700, Ro************@gmail.com wrote:

How are you setting the refresh rate?
What version of Access are you using?
When you say "viewing tables", you mean "viewing forms, which are
showing data stored in tables", right?

-Tom.

Ok, so I've set up a database over a LAN and got it working. I split
the FE and the BE and I have the client computer accessing the BE on
the host computer. I figured out how to set the refresh rate so that
the FEs update themselves (I set it to 5 seconds for right now). The
databases refresh fine, my problem is, the FE on one computer doesn't
actually save changes to a record it has editted until you quit Access.
Here's an example of what I mean: Both computers are viewing the same
tables from the BE on the host computer. The client computer changes a
single record. The host computer keeps refreshing every five seconds
but the change doesn't show up. But if I exit MS Access on the client
computer (the one that changed the record), the change shows up in
exactly five seconds on the host computer. Why does access only REALLY
save the record after you exit the database? Even if I hit the save
button the change doesn't show up until I exit.

Thanks for any help,
-Robert


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.