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