S
Steve Marshall
Hi all,
I have an application where multiple workstations can have the same form
open, adding records to a table. My question is - should Access
automatically cause newly-added records to appear on all the screens, or do
I have to explicitly do a Requery periodically? I was under the impression
that a dynaset-type recordset would automatically cause this to happen. If
that is so, what can cause it NOT to happen? If I am wrong, someone please
put me out of my misery. Surely this is a very, very common scenario.
I'm using Access 2003, and the data file being shared by all the
workstations (via linked tables) is an Access MDB. In the form properties,
the Recordset Type is set to "Dynaset" and the Record Locking is set to
"Edited Record". In the query properties these settings have the same
values.
Thanks
I have an application where multiple workstations can have the same form
open, adding records to a table. My question is - should Access
automatically cause newly-added records to appear on all the screens, or do
I have to explicitly do a Requery periodically? I was under the impression
that a dynaset-type recordset would automatically cause this to happen. If
that is so, what can cause it NOT to happen? If I am wrong, someone please
put me out of my misery. Surely this is a very, very common scenario.
I'm using Access 2003, and the data file being shared by all the
workstations (via linked tables) is an Access MDB. In the form properties,
the Recordset Type is set to "Dynaset" and the Record Locking is set to
"Edited Record". In the query properties these settings have the same
values.
Thanks