Looking for best solution

Hello,

I need to determine the best way to take a database in Access 2000 and
enable 7 field operaters to update infomation in the field and then have
their updates entered into the master database in the office.

The database has a master table with customer data and each field operator
would update relevant information in a secondary table linked to the master.
By allowing them to update in the field on their laptops they would only need
to do some type of syncing with the master database. This sync would update
the master database and then give them an updated copy of the master table.

They need to be able to view the master table information but only adjust
the information in the secondary table. The master database table is
adjusted and added to throught the day by the office staff.

I am not sure the best course to take: FE/BE model in Access 2000,
Import/Export, or multiple databases linked to the master database

Thanks,
tonkle

.

Relevant Pages

  • Re: Looking for best solution
    ... > enable 7 field operaters to update infomation in the field and then have ... > their updates entered into the master database in the office. ... > They need to be able to view the master table information but only adjust ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Cluster will not fail over.
    ... Senior Database Administrator ... >> As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... >> able to restore the master database. ... >> a cluster installation you'll have to revisit. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cross database granting
    ... connection will default to the master database. ... You could enable cross database chaining ownership (whatever it is called, ... > Chris Buys ... >>> the EXECUTE priviledge. ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Re: Cross database granting
    ... When I login as sa, ... > connection will default to the master database. ... > xp_cmdshell implicitly if called from a proc in the app database. ...
    (microsoft.public.sqlserver.programming)
Loading