Hi Chris,
If you have not already split your database into two .mdb files, now is the
time to do so. You should create what is commonly known as front-end (FE) and
back-end (BE) files. The BE includes the tables with the shared data and is
placed on the file server. The FE contains all other objects (queries, forms,
reports, macros and modules). A copy of the FE is installed on each user's
local hard drive. Here is more information on this topic:
http://home.bendbroadband.com/conradsystems/accessjunkie/splitting.html
In answer to your first question, yes, there is a way to kick people out,
but you need to set this up in the FE file first. The only reason that you
would need to kick people out should be to do maintainance work on the BE
file. A nicer method involves preventing new connections, and causing a
message box to display requesting that people end their session so that you
can perform your maintainance work.
For a multi-user Access application, here is a list of things that you
should do:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html
If you send me a private e-mail message, with a valid reply-to address, I
will send you a zipped sample database. My e-mail address is shown on the
bottom of the contributor's page indicated in my signature below. Whatever
you do, please do not post your e-mail address (or mine) to any newsgroup
message.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I have built an Access database that will be used by multiple users.
There are actually two questions:
1. Is there any way I can kick people out of the database so I can make
modifications?
2. I JUST created a database, and the system is now saying that there is
another user in it currently and I can't modify it. When I tried to Compact
and Repair, the message stated that the other user was me! I tried shutting
down, etc. and it didn't work. Can anybody help me with this.
Thanks in advance.
