We have 2 locations (non-profit---YMCA's) about 10 miles away from
each other. There are only 2 computers at each location. We thought we
could hook in and make live changes to the database, like scanning in
members, signing them up for classes, etc. I'll call our main database

All,
I have a split FE/BE application. The Front Ends were distributed to
the different users, The Back End/Tables and Data were installed on
the shared network drive.

Can anyone tell me why only one user is being thrown out of Access when she
attempts to open a form?  There are several users, each with his/her own
front-end on the desktop , linked to the back-end on the network drive, and
everyone else can open the form fine.  Appreciate any ...

I have an Access XP database for multi-users. Front end and back end on a
Windows 2000 server using terminal services on a domain controller with
active directory.
The program runs just fine except that whenever I exit the database I get

I have a database on a network with more than one client accessing it. Most
of the time the clients will only be reading from the database, so I want
to program it to use read-only mode so that if a second client needs to
write to the database, the first client won't unnecessarily ...

I'm a new guy with access data base, I have created a form
based database, and I like the way forms work. I need to
allow the data base to work over network with multiple
users, each having the ability to

i have a VERY basic database...a mere 2.4 MB in size...on
a network drive.  my challenge is Access is not allowing
two end users to make changes at the same time.  i've
split the database - to no avail.  Access continues to

I would like to create a shortcut that will start Access,
open a specified file, and cause the user to use a
specified MDW.
Is this possible?

I want to send a query from Access to Excel, using code, where I can
determine to which directory and folder it shall go. I also want to have the
possibility to name the excel-file to my own liking. Using the button in the
tools menu sends the query to a predetermined folder and ...

I have a database that is on a shared drive and when the
users try to access it they are getting read only
message.  I have check the premission on the computer and
everyone has read/write access on the drive and folder.  

Is there a way that you can cast off a user that has left
their machine with tables open.
The database is a file sitting on a WIN2K file system on a
network and the user is connected to the database through

I am having trouble with an 'Insert' statement.  The same code works
well with all other tables with which I am working.  It's basically
inserting data from identical tables to archive it.  But, the table
below will not accept any records - RoleCategory is numeric, indexed

Any body help me how to get current user name, user loggin
user name. what will be the code. thanks in advance.
krish

The database is setup in two MDB files.  The code is in one MDB files with
linked tables to another MDB file.  When the user signs on, he/she selects a
customer which re-links the tables if needed.
If another user in the the DB (and not really doing anything) the

Here's my situation.  I made a Customer billing program for our
company to use.  We now want the access database to reside on our
server so the rest of the people in the company (all 4 of us) can
access it without emailing the DB back and forth.  I created this