Question 2 - Will MS Access support the dispatch stuff once I build it? Or is
there another program (like MS Access) that I should use instead.
Could you rephrase the question? You want to use MS Access instead of using MS
Access!?
The reason the dispatch system I built was not adopted by the agency was that
- over my objections - the user set it up over a Wide Area Network, with the
backend tables in one city and four frontends in other cities, interacting
over a 100K network. NOT a good idea! Storing the data in SQL server with
properly designed frontends linking over ODBC would have worked (and is
working fine for another client).
John W. Vinson [MVP]