Someone please help me!
I need to design a db for our course department that will
track our course participants and the courses we've done/
when we've done them. Just when I think I've figured out

I receive the following error message when I try to open a
table: "Property value is too large. (Error 3309)
You are trying to set a property value of an object to a
size greater than the largest permissible size of 2K.

I've set up a table structure with all the correct one-to-many
relationships, etc., just as I've always done, but this time, whenever I
open the relationships window, there appear several 'phantom tables' with
the same names as some of the others but with an "_1" extension. What's

Using Access 97', is there anyway to put gridlines on a
report?

I am supposed to design a database for tracking subcontractors license
requirements for a construction company. Years ago I did this in FileMaker
and it works fine, but it is not a relational database.
The problem is that many values in the fields are calculated by dates of

CAN ANYONE HELP ME WITH THE FOLLOWING PROBLEM?
HOW CAN I CREATE A FIELD IN ONE TABLE THAT IS THE SAME AS
A FIELD IN THE SAME TABLE.
"NAME1" MUST BE THE SAME AS "NAME2"

I have been trying to find in the 'big white book' the procedure for adding
new fields to an existing table with zero luck.
I am using Access 2000. for my application which has 13 provincial
databases. All of these databases are identical in structure. A person who

I need to count the number of records in a table, can
anyone help or point me in the right direction?

I am attempting to combine selected fields from 3
different tables so that I can output the result to an
Excel file, thereby allowing me to import into ACT! as
one database.

When developing an application that uses ADO, do I just
have to open the database connection once and close it
once?
Can the connection ever be lost?

I have a problem that is driving me nuts and I'm hoping some the
experienec professionals here can help. I have a database that is used
to keep track of students and their classes (in the database refered to
as orders for a couple of reasons) and the order's payments. I'm

I want to set up a single field for social security numbers (###-##-####) as
well as corporate tax ID numbers (##-#######).  Does anyone have the
settings to do this?

I am linking an excel sheet as an access table but acces
is reading a field that should be text as a number and
givng me garbage.
The problem may be related to the fact that the sheet

I've created two tables one called tblFileInformation the
other tblChecklist, with a one-to-many relationship
between the two tables with FileInformationID as the
common denominator with a join type of 1 - include rows

I have a field which contains data with a primary key and
provides the relationship with other tables.  
Example of data
0300015 DKGMK4277