I hope some one can help me with this, i need assistance
designing the tables and their relationships for a
database
being built around a driving school.

Hi,
I have made changes to a database, in the meantime, users
have added data to the old version. I copied the new data
into the new version however I was not able to use the

First of all - I am not a new designer- just running into
a situation that is taxing my design brain cells, so I am
building a database for a religious education program
where the main tables include Family Info, Child Info,

Here is a link to the relationships window for a database
used to keep track of patients who are enrolled in one or
more studies.
http://members.cox.net/kheisler6/Studies.jpg

I am trying to create a field in my table that would
include a users' initials and date of any changes made to
data in any row of thetable. And it would automatically
refresh this information so that if the last change made

I have multiple access 2000 databases that are all in the
same directory on a W2K server - I'm migrating that server
to a newer rack-mounted server, and have copied the
directory containing the databases to the new server.  

Im having problems,i know Access 2000 does NOT allow you
to use the number "0" as the first digit in "numerical"
data type.I currently use text,which does do the job,but
it does allow non-numerical data used.

I download data from an IBM AS/400 into a table weekly.  
This table contains over 2 million records.  I need to
find the best way and the fastes way of deleting such a
large numober of records.  I have tried both manually

Is there a function that will move text from one field
and append it to another?

I'm running into a problem with my relationships and I was
wondering if anyone would be so kind as to take a look at
my table and let me know if they see anything that would
cause my problem.

I have a table with a list of clients with a field dividing them into months.
( 1 for Jan,2 for feb,etc). Once a month I need to print a list report with the
associated clients for that month.
I use a query to filter my table, But of course have to change the value of

Hello.  I am in the process of diagnosing and correcting an Access 2002/XP
database error.  I have noticed that an Autonumber field used to hold a
PurchaseOrderID (that is its name) recently "jumped" from 15000 to 2800000,
that is from 15 thousand to nearly three (3) million.  What ...

I want to distinguish between Yes, No, and null (or True, False, and null).  How should I design my table?  Can I make the field's type Yes/No?  Or must I type it something else?  If so, what is the correct data type
Thanks.

Designing a database to manage Project history. I'll
describe a sample.
There are 15 people who might be involved in the project.
Each project will have 3 to 10 of these people working on

I have created a multifield index on a table that is usually searched on
those fields in combination.  But there are also situations where one of
those fields alone is searched.  Do I need to create another index for that
single field or will Access97 use the information in the ...