incident database on LAN

[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.

 

[Cheese_whiz]

Hi Philip,

Here's some info on splitting an access file into front and back ends.

http://www.databasedev.co.uk/microsoft-access-mde.html

CW

 

[Jeanette Cunningham]

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 Cunningham]

also try this website
http://databaseanswers.org/data_models/index.htm

it has many examples of data models

Jeanette Cunningham

 

[Philip Loh]

Jeanette,

Thanks for your reply.

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

Regards,

PL

 

[Jeanette Cunningham]

My best suggestion is the website
http://databaseanswers.org/data_models/index.htm

Jeanette Cunningham

 

[Tom Wickerath]

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
__________________________________________

 

[Philip Loh]

Tom,

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

Many thanks.

Regards,

PL

 

[Chad]

Philip, I created one a while back and here is the sample of the full DB.
Hope this gets you started....

http://www.access-programmers.co.uk/forums/showthread.php?t=137731

 

[Tom Wickerath]

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 Wickerath]

Hi Chad,

This looks like a cool sample. If you care to contact me by private e-mail,
I have some suggestions that you might want to consider. My e-mail address is
available at the bottom of the contributors page shown in my signature.


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

 

[Chad]

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!

 

[Tom Wickerath]

Hi Chad,

Scroll to the bottom of this page:
http://www.access.qbuilt.com/html/expert_contributors.html

You should see a link that reads "Click Here To Send Message". I don't want
to post my e-mail address to the newsgroups, given that spammers love to
harvest them.


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

 

[Philip Loh]

Many thanks, Chad.

PL

Philip, I created one a while back and here is the sample of the full DB.
Hope this gets you started....

http://www.access-programmers.co.uk/forums/showthread.php?t=137731

 

[Philip Loh]

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