My database includes the tables, ORGANIZATION (name and address of a
business) and CONTACT (name and _personal_ address etc. of contacts at
an organization).
Key field for ORGANIZATION is OrganizationID.  Key field for CONTACT

I'm in charge of a membership database and am using Access
2000.  I'm having trouble with the initial setup and the
relationships.  I created 4 tables and tied them together
using the MemberID field.  The member ID field is a

I was getting the generic "sorry, can't do that" error when
I tried to import several Excel worksheets into 1 Access
table, so I brought them over as separate tables.
How can I combine them now into one table? I'd rather do

Is it a bad design to have a primary key a procedures table, be a child key
in multiple sub procedure tables. I am writing a database that has a
procedure table with 25 yes/no fields. If a field is checked yes then a
button will enable. Clicking the button will open a second form. ...

Form A and form B both have a related field
How to keep the record in form B even tthe related record in form A was deleted
Thanks.

The UNC looks something like this \\serverlevel1\serverlevel2\folder1\filename.mdb.  Does this address have something to do with extreme slowness searching.  Select query is looking for all active records for assigned to a specific person.

Is there a limit to the number of one to many relationships on a PK in a
table. I am using Access 2000 and need to use several junction boxes for
many to many relationships.
Steve

Please help
I have built a massive database to handle my record business which handles pictures, mp3's and exporting html. I now want to use the artist field to search on 4 different sites when i click on a button called WEB. This is way out of my league
Exampl
Artist : PERFECT ...

When I copy data from an Excel spreadsheet and a cell
entry begins with an " I get a pasting error for that
whole row stating:  The field is too small to accept the
amount of data you attempted to add.  Try inserting or

Folks
Can any one help me in letting know how i can create a access table programtically from a Recordset
Thanks in Advance
Dins

We have a simple table set up for customers.  The table only consists of 4 fields, CustID, Last Name, First Name, Middle Initial.  All fields were originally set up as text for "data type".
We are now trying to change the CustID's data type to number.  This is also our primary ...

I have some fundamental understanding of relational table design and how to
join them properly.
However, I'd like to read up on some more sophisticated ways of table
design.

1.  I have a table :"BuyerSeller" it has ID#, Company, Contact, Tel, City State, etc.( I keep track of all my BuyersSellers info in here
I have another table called "BuyerWants" (every time a Buyer has a new need for me to find an item I would post it here) I go into the field ...

Need to have two switchboards running off the same
database.  I need to have one switchboard that makes
available only reports "read only" , while the other is a
working system to record invoices, orders and fund

HELp save the remainder of the hair I have not yet pulled
out.!
My question is I have a form that has freight and
material, and a field for total, when I use =[freight]*