Solved

Directly run insert statements

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

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

679 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