Re: Looking for best solution

You can add a field to a table and use an update query to change the value
in that new field.

If you have a master database, and want to "merge" changes into it, take a
look into replication.

Good luck

Jeff Boyce
<Access MVP>

"Tonkle" <Tonkle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB3EF53F-75CE-4B17-A126-52240727BF0C@xxxxxxxxxxxxxxxx
> That is a good idea...I did not realize I could do that, it would make it
> alot easier to work with..
> ...currently the master table includes all customer data and the field rep
> table (which they enter shipping, installation and completion dates and
other
> misc info) is linked by job number...
> ...I was originally going to put in an additional field for Field rep
> assignment...can I do that and assign ownership to the line through that
> field or am I going to have to recreate the table?
>
> Also, would I then still use the replication method of updating the data
base?
>
> Thanks,
> Tonkle
>
> "Jeff Boyce" wrote:
>
> > I urge you to re-think your data design. Access is a relational
database,
> > and you will get the best use from it by designing normalized tables.
> >
> > This means ONE table, not 7. If you add a single field to designate
which
> > laptop/field rep/whatever "owns" the row, you could put all the data in
one
> > table.
> >
> > Good luck
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "Tonkle" <Tonkle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:B78DC4D7-23BF-4356-ADE3-7D8621B05C95@xxxxxxxxxxxxxxxx
> > > Thanks Jeff for your response,
> > >
> > > I want each of the 7 laptops to only have access to change the data
> > relevant
> > > to them (ie their own table) which should not be accessable to anyone
> > else
> > > unless they were accessing the master in the office. Each of the 7
will
> > > haver their own table to keep them from accessing someone else's data.
> > >
> > > I will look at the replication newsgroup if you think that might be
the
> > best
> > > solution...
> > >
> > > "Jeff Boyce" wrote:
> > >
> > > > 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

  • Re: Failure recovery for ADAM master
    ... central site instance. ... you tried this when FSMO roles are not reachable? ... think about the impact on replication if you lose your hub site as the NTDS ... master instance (I mean 'Site' in AD/ADAM jargon, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Failure recovery for ADAM master
    ... you tried this when FSMO roles are not reachable? ... think about the impact on replication if you lose your hub site as the NTDS ... master instance (I mean 'Site' in AD/ADAM jargon, ...
    (microsoft.public.windows.server.active_directory)
  • Re: robust OpenLDAP installation using replication in production env
    ... >>In order to get a failsafe environment we need the replication. ... >>specification because write requests to the ldap server should ... > Actually they are redirected to the master. ...
    (comp.os.linux.misc)
  • Re: robust OpenLDAP installation using replication in production env
    ... > replicated OpenLDAP solution on two linux hosts. ... > In order to get a failsafe environment we need the replication. ... We have around 1000 pcs in multiple locations, where the master ldap server ... Actually they are redirected to the master. ...
    (comp.os.linux.misc)
  • Re: Question about domainprep
    ... ADPREP /FORESTPREP on the schema master (update schema) ... ADPREP /DOMAINPREP on the infrastructure master ... To disable SYSVOL replication on a DC: stop and disable the NTFRS service ...
    (microsoft.public.windows.server.active_directory)