I am trying to create relationships between tables to do the following but
Access dose not create the type of relationship I require. I need to get my
table design correct so that Access knows what sort of relationship should be
created.

I tried to create a DSN to Oracle9i database. I could not connect to the
database. I get the error " ODBC conncetion failed"
Whereas I can create a DSN and connect to an Oracle8 database.
Any help is appreciated.

I have a form called (frmComments) whose recordsource is a table called
(tblComments).  The tblComments table contains comments for multiple students
for mulitple examinations.  When viewing the Form (frmComments), I need to
"filter" the recordsource so that I only see comments ...

I have an Access 97 database that has 3 linked SQL tables.  When I created
the links using my user account, then when I deployed the database, the users
logging on under a generic domain account could not access the tables. The
error is  "ODBC Connection to 'SQL_TableXYZ' failed ...

I want to be able to create a look up column that has subheadings. This will
be used to select an Industry type. So there are 5 different types of
industries and within the industries there are choices.  Can I do this in
access?

I built a web app that uses the autonumber for an order id in an Access 2000
db.  Occasionally, a number or two is skipped (the customer insists they are
not deleting records).  The asp code is doing a rs.update to insert the new
record.  

When creating relationships in the relationship window I have been following
a rule “Always drag the bold field onto the non-bold field” (I don’t know why
someone just told me that was the way to do it).
What do I do if both my fields are bold? Does it matter which I drag on to

I asm creating a database which lists a number of people.  Each of those
people is responsible for many buildings.
Within my table I would like to enter each person and then a list of the
buildings they are responsible for and then link this to another table which

Hello. Can anyone help me find an gen. template for human resources or
employees. Thanks

I have not worked with the currency values in MS Access before.
However now I find myself having to now include this information in a
database.
My question is simple, I assume I use the currency data type and not number.

When compacting my database, towards the end of the process, I get the
following message: "Description not found" or "Description missing"
The database continues to run without obvious symptoms and seems to run as
designed. What would cause an error like this and how can I fix it. ...

Hi! I just started a new database called Benefits. It is going to be used to
calculate the rates of employees and their families paid by the company. I
was basically given a format for a report and asked to make it possible. For
the last couple of days I have been trying and ...

Hi does anyone out there have a good operable data base for the recording of
Job / Position Applicants - it would need to have  contact data,
qualifications, skills, and job history

I have a table with 5 Y/N fields.  I want to make it required that only one
can be checked.  I know how to do this at a form level.  However, I think
that people who build update queries and change data in the table forget to
clear out the old field.  I want to force this at ...

I have pretty much built my database to keep track of teams and what they
have won over the years. My dilema is keeping track of teams once they move
or rename themselves. I don't want to lose historical team names or past info
about them.