I want to know the capacity of access database 97 and 2000.
I have an access database  which is used for OLAP
solution. One of table has over 2 million rows these days
and I experience significant degradation in the process

Ignore the first two paragraphs....(I just needed a whinge and my wife
doesn't care about such things!)
When I started with Access 2.0 this form and that form and normalization
didn't exist. I have been told that this is my answer but it all seems like

All
I want to create a simple database with three columns containing a name in
the 1st column, another name (related to the name in the 1st column) in the
2nd column and a name ID number (again related to the 1st column name)  in

I want to design/automate a new table using certain fields
(with different types of data)from several different
tables located on another network.
Example design of  

My friend ask me to help him developing a database for his restaurant and I
come up with 3 tables.
tblMenu
   MenuID

I support 8 different online courses.  Each new student
enrolling on a course sends in a completed Induction
questionnaire.  I have to respond to these answers with
some set responses.  Each induction questionaire has 10

I have several tables linked together but some of the relationships
are being displayed as 'Indeterminate' in relationships view. What
does this mean? How can I get around it? Is it possible to force a
relationship such as one-to-one?

Access 2002.  The LastUpdated method does not appear to be
working.  I do the following on the table "Facilities"
dbs.Execute "DELETE * FROM Facilities;"
DoCmd.TransferSpreadsheet acImport,

I have to keep inventory records. i have designed 3
tables:
items: item_id, name, qty
issued: transaction_id, item_id(FK from items), qty_issued

I'm creating a database of my family and extended
relatives.  I need to keep track of mailing address, phone
number, birthdays.
Reports need to create.  Mailing labels, listing of family

Is it possible to create a loop that will open my linked
Microsoft Excel table and insert a column called Full
Grant Number that concatenates the pre-existing fields in
the table called Full Grant and CAN(Common Account Number).

I have an application Backend in Access97.  Unfortunatly
the original administrators and authours used an
autonumber field as actual data in the database.  The
other day someone got into the backend and deleted

Have time values generated by server log
in terms of minutes & seconds.
i.e. 32:15, 45:32.  These are values of
how long user was logged onto server,

just by interest:
if I append a field to a table programmatically, is it possible to change
this fields position in the table by code also?
i used SQL to append an AutoNumber-field "Key" to an existing table.

How do I do the following:
I want a Discount table which contains a quantity (or quantity range)
and associated discount. For example -
Qty    Discount