Closing users out of application

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

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
 
Back
Top