Is there a way to make Access automatically select "yes" to all the prompts that appear when you run an append query?
I was thinking there was, but I can remember how to do it.
Thanks!

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

use the SQL query ( insert into statement) in access to append your records, for example

this is using northwind sample database

INSERT INTO Orders ( OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry )

SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry
FROM Orders;

Will this replace the old records though or will it just add them on the end of the table. I'm asking because I need it to replace all the old records with the new ones.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

The insert will append to your existing records. In the case of the example I posted not all records will be appended because the orderID is a primary(autonumber) key and does not allow duplicates. In your case if you have a primary on your table when appending your records leave out the primary because it will be atomatically assigned.

For deleting the records before inserting
create a delete query for records you want to delete then run the append(insert into). keep in mind that is always best to specify your select query with a "where"clause

for example
insert into <destinationtable>(CustomerID, EmployeeID, OrderDate, RequiredDate)
select CustomerID, EmployeeID, OrderDate, RequiredDate
from <sourcetable>
where customerID="customerID"