I have been developing a very large database over the past
5 years. Recently, the message "Too many open databases."
pops up while running a particular report. Searching
Microsoft's website yielded nothing helpful -- only that

I am trying to index 10 fields under one index, I have
read and followed the steps on the help files for
creating a multiple field index however it does not
appear to be working; the fields will allow duplicate

When I tried to change the text format of a table with
more than 10M records, a message of "insufficient memory"
was poped up. The action was to change the length of one
the fields from 7 to 10 characters. The action was

I am trying to create a Status Database, you know for weekly statuses of  projects, I am trying to create a form that would show current and
previous weeks info (status), I have a couple of pulldown menus to show the person and another one for the project (for current week). My ...

I have a table with a hyperlink field. I have set the
hyperlink base in the database properties to c:\folder.
I want the user to be able to type in the document name in
the field without having to use the "insert hyperlink"

I have a two field table, where the first fields allows a
user to choose from a drop down box a list of categories
(from a table).  
Based on their choice of category, the computer runs a

Is there a limit to the number of records that can be
accumulated in a single database?
Also, what is meant by a maximum of 32,000 objects in a
database?  Does this include records?

In Access 2000, is there a setting somewhere to fire an error when a user
tries to save a record wherein one of the required fields is not filled in?
I have a new database where, when one of the required fields is not getting
filled in, the record does not get saved, but Access is ...

I have been making substantial changes to the data base I
am developing; removing / changing keys, changing
relationships, etc.  I have not discovered any unexpected
errors when I am working with the db.  However, when I

Please excuse me - I need to re ask this question = I want
the addition to go into the table directly under six
seperate columns so that I may total them, but I cannot
figure out how to get the formula into the columns

Is there a way to add the number of yes/no's in a yes/no
column that produces a check mark on yes - if so can you
please help me with how to do this.  Thank you
Katherine

I am trying to designate certain months to update records
and can't find a way to get Access to recognise months. I
just want to type the month into the field in the table
and be able to sort the records by month, having it start

Hi I have a small table that records the absents of students in my school
Field names are: IDabsent, social sucurity, date_absent, reason
How can i avoid that an asbent of a student is entered twice?
Hermie

When I create a new database table, and use a text field Allow Zero Length
is always set to "No". Is there a way to set the this defaults value to yes
whenever a new table is created?
Presently, I go through the table and have to catch every text type field.

I am fairly new to database programming but I am excited :)
So I started out with 2 tables and wend to the relations editor.
And...I got stuck.
Here is what I did: