Closing users out of application

Hi,

I have created a sales application for a couple of sales
reps. Many have requested changes and additions to the
app. One of the problems I have is that one or more reps
keeps leaving the application open all day and preventing
me from making any modifications. Is there a way to
close the application and knock every one out of it. It
is a read only type of application that gets added to at
night so there is not data input issues.

Thanks,

Chuck

Hi Chuck

The best approach is to split your application into two mdb files. One (the
data file) contains only the tables, and resides in a place that everyone
can share. The other (the program file) contains all the queries, forms,
reports, macros, and code, and uses linked tables to connect to the shared
data. Each workstation has its own local copy of the front end. This allows
you to easily modify your front end, and then distribute the update to each
user.

There is a built-in splitter: Tools | Database Utilities | Database
Splitter.

We have been using this approach since version 1, and never write any other
way. More information:
http://allenbrowne.com/ser-01.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.

"ChuckW" wrote in message
...

I have created a sales application for a couple of sales
reps. Many have requested changes and additions to the
app. One of the problems I have is that one or more reps
keeps leaving the application open all day and preventing
me from making any modifications. Is there a way to
close the application and knock every one out of it. It
is a read only type of application that gets added to at
night so there is not data input issues.

Thanks,

Chuck