Re: Looking for best solution

If you are saying that there's a chance the 7 could each/all modify the same
record (and even if there's no chance), take a look at "replication" (check
in the replication newsgroup, too).

--
Good luck

Jeff Boyce
<Access MVP>

"Tonkle" <Tonkle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0BEA573B-9470-4394-A1B5-3D232B604ADD@xxxxxxxxxxxxxxxx
> 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

  • 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