[Webinar] Streamline your web hosting managementRegister Today

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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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