Re: Access2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: HeinzD (HeinzD_at_discussions.microsoft.com)
Date: 09/08/04 

Date: Tue, 7 Sep 2004 22:53:06 -0700

Hi Allen,
I presume you suggest that I consolidate the data base into a security
enabled one and do away with the front end / back end design. Is that
correct?
Can I follow your suggestions on a front end / back end design also? If yes,
the log tables would have to live on the respective users PC, right?
Please advise.

"Allen Browne" wrote:

> The number of users should present no problem at all, assuming 100Mb
> Ethernet wires (no unstable connections such as WiFi).
>
> You can log users in by specifying a startup form (Tools | Startup), and
> using its Open event to insert a record into your logging table. This link
> will give you the name of the computer:
> http://www.mvps.org/access/api/api0009.htm
> or if you prefer the network user name:
> http://www.mvps.org/access/api/api0008.htm
> If you want to log users out, open a hidden form, and use its Unload event,
> since there is no Application Close event.
>
> If you want to create a log of all inserts, deletions, and edits, see:
> http://members.iinet.net.au/~allenbrowne/AppAudit.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "HeinzD" <HeinzD@discussions.microsoft.com> wrote in message
> news:8AD0E485-02EF-4FE0-8533-5C7D9468C366@microsoft.com...
> > Currently we run Access 2003 on several machines on XP pro machines
> > networked
> > with Microsoft Networking.
> >
> > All the tables are in a separate and central database on a LINUX server.
> > The
> > application is running on each individual machine with the tables linked
> > to
> > it.
> >
> > Is it possible to have users log on and to be able to track who does what
> > to
> > the data in the central tables? I'm a bit concerned that if I let
> > everybody
> > run the same application, shared, from the server it would create too much
> > network traffic and slow everything down. We have 2 or 3 regular users and
> > another 4 or 5 occassional users who could also just look at the data
> > without
> > being able to change things. Total network at present is 16 machines,
> > about
> > half of them laptops.
> >
> > Any advise would be very much appreciated.
> >
> > --
> > Heinz Diefenbruch, MF Vic
>
>
>

Relevant Pages

  • Review my resume. Please.
    ... communication, interpersonal, and problem solving skills. ... MOST and CAN (Controller ... network devices for automotive industry based on MOST (Media Oriented ... the Open Systems Interconnect reference model; design focused ...
    (comp.arch.embedded)
  • Re: FAA: Boeings New 787 May Be Vulnerable to Hacker Attack
    ... determination if that design is compliant with the rules (14 CFR Part ... Special Conditions: Boeing Model 787-8 Airplane; ... network architecture is used for a diverse set of functions, ...
    (rec.aviation.piloting)
  • Re: Is AI all about time?
    ... The "high level thinking" network is NOT A DIFFERENT TYPE OF NETWORK from ... "I think it will be possible to build strong generic learning ... ALL REINFORCEMENT LEARNING PROCESSES INCLUDE BEHAVIOR ... us the ability to design. ...
    (comp.ai.philosophy)
  • Re: FAA: Boeings New 787 May Be Vulnerable to Hacker Attack
    ... that design is compliant with the rules. ... Special Conditions: Boeing Model 787-8 Airplane; ... network architecture is used for a diverse set of functions, ...
    (rec.aviation.piloting)
  • Re: What did that thread indicate?
    ... Or do you mean *this* net has limitations but the ... *right* kind of network, using these nodes, will ... The same thing could be said for a neural net, ... current "flat version" design will not work. ...
    (comp.ai.philosophy)