Doreen- Users shouldn't be sharing a "temp" table. Each user should have a local copy of the "code" - forms, reports, modules, and any local working tables. Only the data should be shared via linked tables to an mdb file on a server.
However, you can avoid inserting existing records by using SQL something like: INSERT INTO MainTable SELECT TempTable.* FROM TempTable LEFT JOIN MainTable ON TempTable.Key = MainTable.Key WHERE MainTable.Key IS NULL John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of rokkeee Sent: Tuesday, January 24, 2006 9:16 AM To: [email protected] Subject: [ms_access] check if number exists in table I have an append query adding new records from a "temporary table" to another "Main" table. Upon closing the form, I deleted all the records from the temporary table. This seemed to work fine until we have more than one user in the database. How can I "check" to see if the MemberID already exists in the Main table and only add the NEW records? Thanks, Doreen Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
