Solved

Directly run insert statements

Posted on 2013-11-14
2
352 Views
Last Modified: 2013-11-15
Hi,

In Access 2013, how to directly execute insert/delete statements against the tables?
0
Comment
Question by:HuaMinChen
2 Comments
 
LVL 33

Accepted Solution

by:
sarabande earned 115 total points
ID: 39650496
in access 2010 you would create a new query, skip the selection of a table. then a button 'SQL' would appear in the ribbon bar which would give a command window where you can type sql statements.

Sara
0
 
LVL 57
ID: 39650903
You can also execute SQL statements in code directly by doing:

CurrentDB().Execute <SQL Statement>, dbFailOnError

There is also a series of articles starting with this one:

Fundamental Microsoft Jet SQL for Access 2000
http://msdn.microsoft.com/en-us/library/office/aa140011(v=office.10).aspx

That walk you through all the SQL that can be used with Access and JET.

Links to part 2 and 3 of the series is at the bottom of the page.

Jim.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 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

23 Experts available now in Live!

Get 1:1 Help Now