I've created a database in Access which is currently being
used by 10 users. I need to modify some of the tables, add
new tables and modify existing and add new relationships.
I do not foresee deleting any fields from any table.

Folks,
Hi. I have an Access file that consists of a single flat file table.
I'd like to create a series of tables that are normalized. I would
like to do this manually, rather than using the Tools>Analyze>Tables

I am using Access 2003
I have a table of nearly 10,000 records which I have
transferred from Excel to Access.  The table consists of
contact names, company names, company addresses and sorts

I would like to represent a variable depth and width
hierarchical structure within an MSACCESS DB what is the
best way to do this?  For example,  the hierarchy may
represent the following product categories:

I am attempting to create a checkbox form that contains
205 checkboxes.  What I need to do is set up the form so
that when the checkbox is checked, the box's label is
stored in the underlying table for later merge into Word.  

Actually, my question is probably very simple, but I
can't figure out where/how to do it !
Here is my problem:
I have a table, with a field called "item" and another

My O/S is Windows XP and so is my MS-Office.  I am trying
to import comments from Excel into Access but the
comments exceed the 255 charter limit.  How can I import
the overflow into my table? I appreciate any help I can

I have a large database that I have to populate with
material. I tried to use paste command fpr all 1000 rows ,
but it's pasting only on the first row.
Is there a way to have all rows filled by paste command?

Hello All, When I query a table for duplicate records I get two records that are very similar but are not the same as duplicates. is there a way to fix this? these are the PartID's I query that are showing duplicates but as you can see they are not really duplicates.

In entering digits into a cell I need to seperate them ex: 193382 to 193/382 how can I do this without affecting all cells?

I want to create a column in a table (with no input
facility) where value in the column is equal to the sum of
the two previous columns, can you let me know how I can do
this,

I have a database application with a table of members and
I used the 'Build Event' to create a query that sorts
selected data into a report (for printing).   This all
works so long as I only have one (field) sorted.

I have a database with a table of employees.
tblEmployees
numEmployeeID (autonumber) PK
strEmpLastName

I am using VB6 to create and load a table in an Access .mdb database.  The table is very wide (>6000 bytes wide) and when I load data there are about 200 rows that load and then I get a 'Record is too large' error which means that the table is too wide.  I realize that the ...

I am btrying to put together a database that will track
rental and how many additional copies I have available
Order table has the item to be rented and a start and end
period.  inventory table as the items and how many of