How to change the tables in edit mode in ADP(Access data project ) ?

How to edit or insert record  in Access data project front end
Who is Participating?
Vadim RappConnect With a Mentor Commented:
Scott, what SQL, look........ lol.

Jessymole123, basically, you open Tables; double-click a table; it opens up; then you edit it. When you leave the record, it gets updated in the database, there's no "save". To add new record, go to the last record and to the next one.

I suggest you look at the materials at this page: , it has lots of training information.

Or you can press F1 in Access and read online Help.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you using bound forms? If so, then Access handles this for you.

Otherwise, you can use standard SQL:

CurrentProject.Connection.Execute "INSERT INTO YourTableName(Col1, Col2, Col3) VALUES(Val1, Val2, Val3)"

Use UPDATE to update your record ... there are a plethora of websites out there which go into great detail regarding the proper use of these basic SQL keywords in relation with Access, so I won't repeat them here.
Vadim RappCommented:
I think my answer was correct.
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.

All Courses

From novice to tech pro — start learning today.