MS Access Databse

Question

How to prevent from getting the same row repeating in ms access 2003?

Amit Gupta · Answer

If you want to insert it only on a single row then update the row like If( rows.count>0) Update command Else Insert command

Ramesh Palanivel · Answer

Hi Sharad Please share some screen shots..

Sharad Hosure · Answer

@Ramesh Palanivel database has a single record but when the query execution takes place the record get repeated.

Ramesh Palanivel · Answer

Hi Sharad Before inserting record check whether the record already exist in msaccess or create primary key for table