How do I run sql stmts in Access 2010? ggl

guu...@gmail.com

unread,

Oct 27, 2012, 2:06:26 PM10/27/12

to

What is the quickest way to run commandline Oracle or MySQL version sql statements inside Access 2010? How? Thanks.

Bob Barrows

unread,

Oct 27, 2012, 2:19:39 PM10/27/12

to

guu...@gmail.com wrote:
> What is the quickest way to run commandline Oracle or MySQL version
> sql statements inside Access 2010? How? Thanks.

Against Access data? You can't.
You can create a passthrough query to pass commands directly to Oracle
without Access parsing them.

Albert D. Kallal

unread,

Oct 27, 2012, 7:27:23 PM10/27/12

to

>wrote in message
>news:d6d1b290-94f3-4053...@googlegroups.com...

>
>What is the quickest way to run commandline Oracle or MySQL version sql
>statements inside Access 2010? How? Thanks.

Depends on what kind of SQL statements? If they are standard, then I often
just hit ctrl-g to fire up the command line, and then type in:

currentdb.execute "my sql goes here"

You can see me do the above in the following video where I have to type in a
few quick and dirty SQL statements and I am too lazy to fire up the query
builder, so I use the ctrl-g to get to the Access command line prompt:

http://www.youtube.com/watch?v=3wdjYIby_b0&list=PL27E956A1537FE1C5&index=2&feature=plpp_video

So I often fire up the command line and just type in sql statements as the
above video shows.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
PleaseNoS...@msn.com

The Frog

unread,

Oct 27, 2012, 7:40:38 PM10/27/12

to

Passthrough queries to the BE database only. You have to make sure
the SQL dialect / statement is correct too as there are differences
between Oracle, MySql, Access, SQL Server, etc...

--
Cheers

The Frog

guu...@gmail.com

unread,

Oct 27, 2012, 10:43:31 PM10/27/12

to

On Saturday, October 27, 2012 4:27:22 PM UTC-7, Albert D. Kallal wrote:
> >wrote in message >news:d6d1b290-94f3-4053...@googlegroups.com... > >What is the quickest way to run commandline Oracle or MySQL version sql >statements inside Access 2010? How? Thanks. Depends on what kind of SQL statements? If they are standard, then I often just hit ctrl-g to fire up the command line, and then type in: currentdb.execute "my sql goes here" You can see me do the above in the following video where I have to type in a few quick and dirty SQL statements and I am too lazy to fire up the query builder, so I use the ctrl-g to get to the Access command line prompt: http://www.youtube.com/watch?v=3wdjYIby_b0&list=PL27E956A1537FE1C5&index=2&feature=plpp_video So I often fire up the command line and just type in sql statements as the above video shows. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada PleaseNoS...@msn.com

Nice thank you. I googled and saw your posts about it here too:

http://www.pcreview.co.uk/forums/acc2000-docmd-runsql-vs-currentdb-execute-t2503687.html

Do you know of a source or document which will tell me which Oracle SQL satements will run OK in Access using the methods above?

Bob Barrows

unread,

Oct 28, 2012, 9:33:36 AM10/28/12

to

The Frog wrote:
> Passthrough queries to the BE database only. You have to make sure
> the SQL dialect / statement is correct too as there are differences
> between Oracle, MySql, Access, SQL Server, etc...

I think that's what I said, isn't it?

The Frog

unread,

Oct 29, 2012, 9:17:29 AM10/29/12

to

Yeah, pretty much Bob. I'm doing this from my phone so sorry for the
confusion. I just kinda read the OP's question and answered it. Good
to see we're both right though!

--
Cheers

The Frog

Albert D. Kallal

unread,

Oct 29, 2012, 10:18:10 PM10/29/12

to

wrote in message
news:52b80034-7360-428d...@googlegroups.com...

>On Saturday, October 27, 2012 4:27:22 PM UTC-7, Albert D. Kallal wrote:
>> >wrote in message
>> > >news:d6d1b290-94f3-4053...@googlegroups.com... > >What
>> >is the quickest way to run commandline Oracle or MySQL version sql
>> > >statements inside Access 2010?

>Nice thank you. I googled and saw your posts about it here too:
>
>http://www.pcreview.co.uk/forums/acc2000-docmd-runsql-vs-currentdb-execute-t2503687.html
>
>Do you know of a source or document which will tell me which Oracle SQL
>satements will run OK in Access using the methods above?

Hum, most standard SQL statements will work. Since Oracle, MySql, SQL server
etc. all have some differences, then the instant you venture outside of
plane Jane SQL is likely the instant you run into trouble.

So, there is a SQL reference in the Access help, but specific to what Oracle
statements will work is likely not available.