Re: Looking for best solution

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: Replication problems
    ... An error occurred while accessing the DHCP database. ... DHCP server event log for more information on this error. ... browser for the domain on transport NetBT_Tcpip_{99B638B5-2C0B. ... master browser is stopping or an election is being forced. ...
    (microsoft.public.windows.server.active_directory)
  • RE: SQL Server failing to start (directly effecting sales!!!) Error: 823, Severity:
    ... You should consider calling Microsoft Technical Support as your master ... They will want your SQL Server Errorlogs ... that the machine with the database has hardware that is failing. ... Even if you are planning to reinstall you should make a backup copy ...
    (microsoft.public.sqlserver.msde)
  • Re: Table Normalization
    ... To master it requires a great deal more work. ... There are so many categories to work in (database design, queries, forms, ... that they'd flub a number of the answers, ... make the same mistake twice, and they don't let others make the same ...
    (microsoft.public.access.tablesdbdesign)
  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)
  • RE: Multi user database
    ... manner and push updates to the backend. ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
    (microsoft.public.access.modulesdaovba)
Loading