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

Posted on 2008-11-04
Last Modified: 2013-12-05
How to edit or insert record  in Access data project front end
Question by:Jessymole123
    LVL 84
    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

    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.
    LVL 40

    Expert Comment

    by:Vadim Rapp
    I think my answer was correct.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now