Solved

Directly run insert statements

Posted on 2013-11-14
2
369 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

856 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