I have a table in sql 2000 backend (be) and Access front end. I deleted the
data from the "be" table. When I tried to append the same data again I got
error message saying that:" Microsoft office Access did not add 1262
Record(s) to table due to key violations". What does that ...

I have a database created by getting external data (outlook folder) and
creating a table.
- I sure hope this updates each time the table is opened... if not I need to
fix that as well....

I have VB code that prompts the user to browse to another database and
TransferDatabase acImport a table (tblCustomers) into existing DB.  The table
name is the same all the time, however a few of the fields are named
differently, such as:  LName vs. LastName.  

I have two tables, one for % values and the other one for employee evaluation
In the % value table, there are 3 fields:
Percent ID>>Primary Key
Percent Value>> points start form 5 to 10

I need some urgent help with a database that i'm creating and i'm a
bit stuck.
I have 2 lists of data they are both linked. I need to create a query
where by if a certain criteria matches on the other sheet then all

Is there a reference book that defines all of the query functions in Access?  
I'm looking for something that describes what each function does and how to
use them.  Thank you.

My table name is Meas_Numericlimit.
Sample Data is as below. ( Different temperature, testcase type,
testcase_suffix is possible).
ID    STEP_RESULT    Dut_ID    Operator    Project    Temperature    TestCase    TestCase_suffix    PARAMETER    COMP_OPERATOR    HIGH_LIMIT    LOW_LIMIT    DATA    UNITS    STATUS

I have a data field ODBC linked to Access that has data in multiple lines of
text. It all belongs as one entry to that field. Eg as below.
RED CELL FOLATE
This added test/s

I have a queiry where I have an expression.
USD_Report_Tot:
[Net_Tot_Pay_USD]+[tot_voy_pay]+[Tips]+[Violations]+[Bonuses]+[Misc1]+[Misc2]+[Misc3]+[Misc4]
I would like to have a criteria that basicly selects all records that are

I need alot of advice from you guys!  Basically I have a table that contains
address data, and I want to isolate the country name - it may be either by
itself in a field or in a string.  
To do this, I have created three tables:

I have an access table with laboratory test results. The table consists of
three fields(see below for a sample table):
Sample Number, Lab test ID, and Test Result.
1                         1                       54

Suppose that I have a table that holds survey results.  The survey has
10 questions, each with 3 results (say A, B, C).  The survey is given
out at different locations.  I need to build a report that gives the
total response for each question by site along with the percent.

I need to turn off the action query prompts in Access '07. Anyone know where
this is found without using vb?

Good Morning,
I am stuck on how to generate the proper calculations to finish off my query,
perhaps you can help. Please see below.
Manager    Site        Advisor                YUSAGE           CONVERTED_1

I am doing a query that has the following expression in it.
Nz([Net_Tot_Pay_USD],0)+Nz([tot_voy_pay],0)+Nz([Tips],0)+Nz([Violations],0)+Nz([Bonuses],0)+Nz([Misc1],0)+Nz([Misc2],0)+Nz([Misc3],0)+Nz([Misc4],0)
The feild [Net_Tot_Pay_USD] the field tot_voy_pay are the rusults from an ...