how do i define a primary autonumbering field in design view

I am having issues with Paste Append.  whenever I try to paste append
and then move to another record my DB shutdown.  I am trying to do
this directly into the table.  Anyone have this issue or know what
might be causing it?

I have started a new post after posting in my old one. I'm not sure this the
right way to do this as the old post has worked its way down the list and
have had no responce.
This started as a table design problem so I hope I am posting to the correct

I wanted to relink and refresh an external text file. It seems Access
always link the same file. It is possible to re link an external text
file and refresh the data?
Your informaiton is great appreciated,

I have a database of "artefacts".
An Artefact has a "Main Type"...and a "Sub Type"
e.g with "Main Type" = "Document"
"Document" has "Sub Types" e.g. "Book, Magazine, Newspaper, Certificate,

Hi, I've taken over a retired engineer's Database which is over 800,000k.  
When Using Compact & repair (I do this on a weekly basis with other databases
with no problems) there is no compress noted.  But instead the database makes
a copy of itself.  Does anyone know why this is ...

So far I been trying merge information from two link tables into a master
file that will update everytime there’s a revision, addition, or deletion of
a record but I been unsuccessful. I know that this can be done but I can’t
seem to find the way of doing this and several people ...

I have created a form with several subforms.  I cannot get it to print on one
page.  Does anyone know how to format for one page printing?

I have a database set up with all the fields, forms, reports, queries, etc
that I need. I have it all connected to a switchboard because there are four
people who will be using this. The problem I'm running into now is that each
quarter there will be new data (fields will be the ...

How do I combine all the information from a Database that has several link
tables into one report that will show everything? The fields in the tables
are the same and are arranged in the same order I just need to put everything
in one place so it can update as information is ...

Good morning,
My question involves forcing a check for duplicates before a record is saved
in Access '03. The issue is that people are entering information through a
form into a record (20 fields or so), and when the record saves, the

"The value you entered isn't valid for this field.  For example, you may have
entered text in a numeric field or a number that is larger than the FieldSize
settings permits."
I tried looking at all of the fields for all of the tables I have and review

How can I program a wordpad entry into a table?
Example:
I have a field and would like that field to be a wordpad entry. I know that
can use memo field, however the memo field is limited. I would like to

I have not split my one database yet although I'm going to. Just a question.
Right now I have the MDB file on a simple file server that everyone uses. It
is mapped as a p: drive. I don't have any security set up yet other than to
give rights to my managers. They have delete, edit ...

I am looking to create a permanent attendance report.
I presently record all absences.
For the permanent record I also need to show when present.
I have a student, absent date, and number of hours absent.