Re: Looking for best solution

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: Looking for best solution
    ... If you have a master database, and want to "merge" changes into it, take a ... > ...currently the master table includes all customer data and the field rep ... would I then still use the replication method of updating the data ... >> Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Looking for best solution
    ... Tonkle ... "Jeff Boyce" wrote: ... >> ...currently the master table includes all customer data and the field rep ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Prevent Duplicates using an Append Query
    ... Jeff Boyce ... Microsoft Office/Access MVP ... append query to update a Master Table in Austin. ...
    (microsoft.public.access.queries)
  • Re: XP dead, tried to convert from FAT to NTFS
    ... Good luck. ... > new harddrive and the full edition of Windows XP and make this the Master ...
    (microsoft.public.windowsxp.general)
  • Re: Singing
    ... Looks like I'll have to record about 50 versions and splice a 'master' ... Good luck! ... Professionally, several takes of each phrase is done, and the better is ...
    (rec.music.makers.songwriting)