I would like to know if it is possible to link records in one table to
columns in another with standard db design (i.e. without coding the addition
or removal of a column when the applicable record in the table is deleted).
I do not want to use a many to many relationship for this ...

I need a table that can record an unknown set of records for testing.  For
example, I want the user to record test results.  But, until the tests are
created, I won't know the information to be recorded.  In one test it may be
months and a required signature of Y/N.  In another ...

I have table that stores a "year" value. Is it better to have this field's
data type as a Text or Number value. There is no dates, just a year like
2004, 1999 etc..
Any suggestions ? Thanks in advance.

Hi all
1) I am rank ameture at Access
2) I am having trouble getting started with a particular database project
3) Words are all I have to express my desperation and hopefully appreciation

I need some help, I need to design the database relationship diagram with the
information given below. I have been asked to design an Access relational
database for a small bookstore that operates 3 stores. Books are sold by a
sales person to a customer through an order. An order ...

I have a very large table.  In a database by itself its about 340mb.
When I try to set the primary key it says "Changing field data types"
then gives me an error "Can't change field data types - Not enough disk
space or memory".  It's not a disk space problem so it must be memory ...

I have used the Database Splitter utility to create a "_be" version of my
database and moved that to the server.  Other computers have code version
with tables linked to the server _be.  
I had previously used VB code in my start up routine that checked the

Is it possible to limit which records in an access database that a user can
see?  I would like to make a database that holds students test scores, etc,
and would like to give them access to the database, but only to view their
test scores without being able to see the other tests ...

When I set up a field in a table as an OLE object so that I can have pictures
of employees on a form, I get this error:
"A problem occurred while Microsoft Office Access was communicating with the
OLE server or ActiveX Control.  Close the OLE server and restart it outside

My project has six table that are related "one to one"
What is the proper way to combine them so I can use them for my form.
Thanks Jake

Friends,
My replicated database began throwing errors without my having changed
the design. The main error, when I try to open a specific table is:
"unknown function name in table-level validation expression"

I am bordering on between basic and intermediate user of Access.  
This is my situation: I have been asked to create a database to hold
information about people and their assessment details.
I have created four tables.  Counsellor, Client, Client Assessment, and

Hello.
I have two tables called Mailouts and Customers. I have a lookup table
between them containing foreign keys from both tables. What I'd like to do is
do a search for customers by certain criteria, then create a new mailing

I want to be able to sort a spreadsheet according to any column heading,
i.e., Date, Name, Type of Case, etc.  However, if I pick a column, it sorts
only that column (A-Z) and doesn't move the rest of the data.  Thus, all the
data gets mixed up and doesn't pertain to the column ...

I'm trying to convert part of an Oracle database to Access (due to budget
constraints, several of our business districts can't afford Oracle but have
Access on their PCs and, yes, eventually it will all be done via the web).  
I'm some what familiar with Access but am having ...