Checking for existing record "Before Update"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I check for an existing record in a SQL database using Access as the
front end? The SQL table has two fields which are both set as keys: Quarter
and Account
 
hi,
a simple select query should do it.
have it promp you for the keys. if the record exists then
the query will show it to you. if not, it displays a blank
query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Action Query (Append) didn't add records due to key violations. 5
Access 2010 append query to SQL is very slow 0
Fixing up field with a row number to become PK 1
Query to duplicate a record with one field updated 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
not in criteria fails 2
Access Access 2010 import/append data into table w/o overwriting existing records 0

Back
Top