My problem is several users who forget to close the database before going
home.
I need to make changes and can't because they are still logged on.
Is there a way I can terminate them, without having to go to each machine

I am holding some processing constants in a one entry table but this causes
problems when other users are involved as they share the same constants.
Could someone please direct me to some help.  Do I need to identify each
user and keep separate entries in the table for each user?  I ...

I get a warning dialog when trying to add a new records to my table through
use of a form.  I suspect, the database thinks someone else is working in
the table, but I am the only one using it.  I had a problem yesterday and
think something got left open when I closed the database.  ...

Hey all. Not sure if this is the right NG.
I've got a database I originally created in Access 97.
However, the demand for it has grown and it now needs to
be shared with some people who have Access 2000. I was

I have an access 2000 program in my office.  I have the identical program on
6 laptops in the field.  I need to figure out a way to update, syncronize or
append the data from the laptops to the master database in the office.  The
laptops are not linked in any way.  I have tried to ...

Alguien sabe la forma de recopilar datos en una base de datos, procedentes
de varias pero que sean todas iguales?
Por ejemplo tres amigos trabajan en sus casas respectivas con una base de
datos igual para los tres, cada uno mete datos diferentes y luego para

Please help me, thanks in advance.
I have installed win2k sp4 on my win2k professional. This Win2k SP
also updates the Jet 4.0 qith SP7.
Using CDaoTableDef::create() I am creating a linked table and using

I am in the process of testing an install where the BE is on a remote
drive (10 miles away) and the front end is on the local machine.  With
one table already open and the BE at the first level (X:\data.mdb),
opening a second table with one record via code varies from 16 to 35

Does anyone know how to script a 'silent' compact?  I need to schedule
and run one from a server for an Access 2000 db.  Launching a GUI (like
what /compact startup does) is not acceptable.
Jetcomp has the right idea but I couldn't get it to script.  I don't get

I need to have my append queries and the tablethey append
to locked down when a user is using them to create a
report.  Because they get crossed data by other users
appending at the same time they are.  Help!

help on design anyone..

I am testing (in Access 2002) a simple multiuser database setup and I am
having problems with a form taking a *very* long time to find a record
(using Ctrl+F).  Here's the setup:
The back end is in a shared directory on a Win2K Pro machine.  It is

Recently I tried one of the recommendations found at
http://www.granite.ab.ca/access/performancefaq.htm to
improve the startup performance of one of my Access 2002
applications.  I was pleasantly surprised by the results,

If I am going to create a Access 2000 ADP and place it on
a webs site, do I need to have an SQL database as well to
act as the datasource?
I would like to test my ADP on a website (views & stored

I am trying to speed up my app which is very slow over the network. In
addition of the general recommandation of opened dummy form, turning
auto-correction off, etc. I have shortened the name of the back-end
database. It did the trick for one app but the some forms on the second app