Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

Stop duplicate records in Access 2010

I created a form in Access with linked tables to data on a SQL server.  When the user enters data into the form (Access) the data is duplicated on the form.  So one line of unique data now turns into two.  I created the form using Form Wizard and chose all the coloums from my Table.  Any suggestions would be great on how to not have the form duplicate the records.  
0
SargentControls
Asked:
SargentControls
  • 2
1 Solution
 
mayankagarwalCommented:
you can define a primary key on the table. or before inserting the row in the table you can check for the existing data if at all it exists then throw an error to the user
0
 
Jeffrey CoachmanMIS LiasonCommented:
"I created a form in Access with linked tables to data on a SQL server."
Then, can you explain the structure of these tables and the links involved...?
Post the ERD (Entity relationship diagram)

There is nothing the form wizard can do that will create duplicate records automatically (unless the code was perhaps modified after the fact).

I would suspect the table relationships first.
0
 
SargentControlsAuthor Commented:
None
0
 
Jeffrey CoachmanMIS LiasonCommented:
None what?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now