My company has 40 stations across the States that use a stand-alone PC which run a vb application using an ACCESS database. These stations are visited by an operator once a month. We are having maintenance problems such scheduled compact and repair finds the database in a occupy state. The databases are 30 meg with one table at a million records.
MSDE sounds like a better solution, but I am not finding much documentation or testimonials. Any comments?