[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2008-11-04
Medium Priority
Last Modified: 2013-12-05
How to edit or insert record  in Access data project front end
Question by:Jessymole123
  • 2
LVL 85
ID: 22875449
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.
LVL 40

Accepted Solution

Vadim Rapp earned 2000 total points
ID: 22875779
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:
http://office.microsoft.com/en-us/training/HA102744471033.aspx , it has lots of training information.

Or you can press F1 in Access and read online Help.
LVL 40

Expert Comment

by:Vadim Rapp
ID: 25204774
I think my answer was correct.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question