I am using Allen Browne's example database sample "Human"
http://allenbrowne.com/AppHuman.html
as a starting point for a database that I am redesigning.  As in his
example the design is based on a definition of a Client as an

I use this to test my databases on a copy of the backend, then use the
linked table manager to change them back to the real back end.  All I can
find is how to link a new unlinked table.

I am an administrator and I have designed a small database which will be used
by my colleagues at work. It's nothing brilliant but I'm confident it more or
less works ok. There are just a couple of forms. The main one contains
details of building sites. The others relate to the ...

I am moving my backend to a server with SBS 2003.  What is the best way to
configure the database on the server and on each client?  I need remote
access to the back end.
Should I store the front-end database on each client, or should I put it on

I have 6 tables. All 6 tables have the arrow and asterisk at the bottom,
meaning they are editable and you can add records. I have autonumber primary
keys and I have indexes on each table on the fields that I am going to join.
Each field that I am going to join is set to long ...

I'm a database newb, so please forgive the following, potential stupid,
question.
We have research trips that we participate in, collecting data every few
minutes.  That part of the database is fairly simple.  One thing that we

I am a bit confused by my relationships and keys. Perhaps someone could help!
My database contains information about sites. The sites will contain houses.
I need to record information on the site, including who will develop it and
the name of the landowner.

Hi I have run out of fields in my main table, there is to much data to use
the Access table splitter. It just keeps crashing with error message not
enough memory which I have spent hours on to get no where.
I still need to add about 34 more fields to capture all of the new data we ...

I've gotten user and management requests to accommodate new data in a
quote system I've developed.
I imagine that I need to take historical data from the history table
and populate a quote table and a quote detail table.

I have created a membership database for our local branch of a charity and
designed various queries and reports to analyze particular trends. The source
table I called Members Jan 08 but I receive updates every quarter and when I
import the new membership list naming it Members ...

Please tell me if I can use the [event procedure] more than once in a form.
If I change the name.  It doesn't work.  If I don't change the name.  The
[event procedure] just moves to from one combo box to the next.  Is there
some way to save a procedure and rename it.

Is it possible to break worksheet out into multiple columns - and break
uniform aspect of it?  In other have a mini worksheet inside a worksheet?  
You break the uniform structure of excel?   I have seen it done i just dont
know how to do it - any suggestions?

I'm using Dsum in a control on a form to total records in a table. It's
working but not until I close the form and reopen it.
What am I missing?
the Dsum is in the control source should it be in the update event?

I want to create a database so that users can enter scores for  a list of
questions. The user will enter their name, the date, and then go on answering
a list of questions. The answers are scores: 0,1,2,3,4, and NA. Later I want
a report showing all the questions and the answers ...

Is it possible to put line breaks in a report?
I have a full page of records (all the same group) and they are hard to
read.Is there some way I can put in a line break every 5 records or so?