incident database on LAN

  • Thread starter Thread starter Philip Loh
  • Start date Start date
P

Philip Loh

Fairly new to Access. Some knowledge on VBA.

Want to set up an Access database for incident reporting ( what, when,
action, etc ) on LAN.

Like to know if you have a sample db for me to get started.

Possible to have multi-users writing to the db at the same time ?

Many thanks.
 
Philip,
Incident is a fairly general term - doesn't give much of a clue about what
you need. There is a database template for Issues on the Microsoft website -
there might be something in it that you can use for an incident database.

Jeanette Cunningham
 
Jeanette,

Thanks for your reply.

By incident, I am referring to accident, e.g., fall down the staircase, who,
when, how, etc.

Regards,

PL
 
Hi Philip,

While it is quite easy to create a single-user Access application, there are
many "gotchas" just waiting to bite you when you attempt to allow multiple
users to start using it. Therefore, I recommend designing with a network in
mind. This includes minimizing the amount of data that must be brought over
the network wire, since a network represents the weak link in the chain. Once
you have a design that you are working with, take a look at my Multi-User
Applications paper, available here:

http://www.accessmvp.com/TWickerath/


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Tom,

That is what I am afraid of, the multiuser access. Thanks for the direction.

Many thanks.

Regards,

PL
 
Hi Philip,

With proper design, you should be able to create a solid multiuser Access
application that can easily support 40 to 50 simultaneous users. The golden
rule is to fetch only the data that a user needs. I have a new tutorial paper
available on the Seattle Access User Group, for a presentation that I gave a
few weeks ago. See the download, available here:

http://www.seattleaccess.org/downloads.htm

Query By Form - Multi Select
Tom Wickerath, February 12, 2008

Download (269kb) Using Multi-Select Options; Word doc and mdb


I will eventually convert this to a web page on my new web site, as time
permits. Make sure to follow all of the recommendations in my Multi-User
Applications write-up. This is a compilation of many years of learning the
hard way. For example, disable Name Autocorrect, set all table subdatasheets
to [None] (you must disable Name Autocorrect first, to get the table
subdatasheets setting to "stick"), establish a persistent connection, use
proper indexes, and use the JETShowPlan registry setting to ensure that you
are not causing any table scans for tables with a large number of records.
For small tables, the query optimizer may very well decide that a full table
scan is the most efficient query. I wouldn't worry too much about tables with
a small number of records, like say 50 or less.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Tom, It wa one of my first DB's and still learning. I have changed alot of
stuff in my current one but I would like to hear your comments! Cant find
your email address though!
 
Like to know whether it is possible to automate sending emails from within
Access if certain criteria are met ( e.g., follow up actions, severity of
accident, etc. ).

Thanks.

PL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relationship Help - Incident and Problem Database 3
Relationship Help - Problem and Incident Database 1
Guide Me 2
Payroll Database - Need Help!! 1
Database relationships--HELP 0
Opening Database & LAN Speed 5
Database Saving/Closing question 1
Access how to open existing database from another database using Access - VBA 0

Back
Top