G
Guest
I hope someone can help or give me some guidance. There are two users who use
the same database. We each have our own copy on our PCs. I merge the table by
using the following in a query to update the fields. Field by field.
Nz([tblTRACKING].[CoName],[tblTRACKING1].[CoName])
Nz([tblTRACKING].[CoName],[tblTRACKING].[CoName])
However, the fields have increased and I was wondering if there is an easier
way to do this? I cannot split db with back end. The share drive where this
would be housed makes the db run very very slow. Our server is on the East
Coast and the users are in the West Coast. The other problem with sharing db
is that the users (2) would be hitting on same data.
Would like to know if there is a way to be able to update all the fields that
need updating at once. Fields consist of checkboxes, dates and text.
Any help will be greatly appreciated. Thank you.
the same database. We each have our own copy on our PCs. I merge the table by
using the following in a query to update the fields. Field by field.
Nz([tblTRACKING].[CoName],[tblTRACKING1].[CoName])
Nz([tblTRACKING].[CoName],[tblTRACKING].[CoName])
However, the fields have increased and I was wondering if there is an easier
way to do this? I cannot split db with back end. The share drive where this
would be housed makes the db run very very slow. Our server is on the East
Coast and the users are in the West Coast. The other problem with sharing db
is that the users (2) would be hitting on same data.
Would like to know if there is a way to be able to update all the fields that
need updating at once. Fields consist of checkboxes, dates and text.
Any help will be greatly appreciated. Thank you.