Online query analzyer for Access?

[jason]

What is the best way to create new queries and/or modify existing tables
within an online access database. At the moment, I am periodically
downloading the db and making alterations.

But, I have heard others on the list say they use a query analayzer built on
a <form> where they execute SQL statements....

Is this the correct way to go?

- Jason

[Ray at]

Here is an online example.
http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

As far as what is best to do, that's open for debate. I personally use
something simliar to the example above. Some people swear by on-the-fly
modifications like this, and others like to do it the hard way. I have no
problem using online mods like this for a site that is using Access, because
you know that it's not going to be a crazy-busy site or anything.

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:OZ**************@TK2MSFTNGP09.phx.gbl...

What is the best way to create new queries and/or modify existing tables
within an online access database. At the moment, I am periodically
downloading the db and making alterations.

But, I have heard others on the list say they use a query analayzer built on a <form> where they execute SQL statements....

Is this the correct way to go?

- Jason

[Aaron Bertrand - MVP]

> What is the best way to create new queries

Issue CREATE VIEW etc. statements against a connection object?

and/or modify existing tables
Issue ALTER TABLE etc. statements against a connection object?
But, I have heard others on the list say they use a query analayzer built on a <form> where they execute SQL statements....

Maybe they were talking about some of these tools, many of which apply to
Access... http://www.aspfaq.com/2442

[TomB]

Uh, oh. Here we go again.... ;)

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Here is an online example.
http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

As far as what is best to do, that's open for debate. I personally use
something simliar to the example above. Some people swear by on-the-fly
modifications like this, and others like to do it the hard way. I have no
problem using online mods like this for a site that is using Access, because you know that it's not going to be a crazy-busy site or anything.

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:OZ**************@TK2MSFTNGP09.phx.gbl...

What is the best way to create new queries and/or modify existing tables
within an online access database. At the moment, I am periodically
downloading the db and making alterations.

But, I have heard others on the list say they use a query analayzer

built on

a <form> where they execute SQL statements....

Is this the correct way to go?

- Jason

[Ray at]

I am still bitter about that. That whole thing really burns me up. That
list kills me. I just feel like it is dicatorishly dominated by a couple of
people who often misguide those with less knowledge and make them think that
there is only one answer to each question. I really think that list is
doing a dis-service to many learning ASP'ers. That's not right, man!

Ray at work

"TomB" <sh*****@hotmail.com> wrote in message
news:e$**************@TK2MSFTNGP10.phx.gbl...

Uh, oh. Here we go again.... ;)

[TomB]

Well, the good thing is, Aaron suggests the same thing as you, and he's a
pretty smart guy (just don't tell him I said that)

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uu**************@TK2MSFTNGP10.phx.gbl...

I am still bitter about that. That whole thing really burns me up. That
list kills me. I just feel like it is dicatorishly dominated by a couple of people who often misguide those with less knowledge and make them think that there is only one answer to each question. I really think that list is
doing a dis-service to many learning ASP'ers. That's not right, man!

Ray at work

"TomB" <sh*****@hotmail.com> wrote in message
news:e$**************@TK2MSFTNGP10.phx.gbl...

Uh, oh. Here we go again.... ;)

[Ray at]

Aaron learned that from me, just like most of the other things he knows.
Oh, wait, I was still using a Smith Corona typewriter when he started coding
ASP pages. I must have this backwards. :]

Ray at work

"TomB" <sh*****@hotmail.com> wrote in message
news:uO**************@TK2MSFTNGP09.phx.gbl...

Well, the good thing is, Aaron suggests the same thing as you, and he's a
pretty smart guy (just don't tell him I said that)

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uu**************@TK2MSFTNGP10.phx.gbl...

I am still bitter about that. That whole thing really burns me up. That list kills me. I just feel like it is dicatorishly dominated by a

couple of

people who often misguide those with less knowledge and make them think

that

there is only one answer to each question. I really think that list is
doing a dis-service to many learning ASP'ers. That's not right, man!

Ray at work

"TomB" <sh*****@hotmail.com> wrote in message
news:e$**************@TK2MSFTNGP10.phx.gbl...

Uh, oh. Here we go again.... ;)

[jason]

Great - that looks like a very usable solution to me. One thing that
puzzles me about the Atrax solution is a reference to:
"...I create a Windows Script Component (by replacing out the path to the
site's main WSC object), and use that to fire the query. "

Is he actually firing this analyzer off his own local server thereby
allowing the use of wsh? If so, how does one accomplish this off a remote
host...

Sorry, I am probably missing something here - the code is kind of complex!

Thanks
Jason

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:#U**************@TK2MSFTNGP11.phx.gbl...

Here is an online example.
http://rtfm.atrax.co.uk/infinitemonk...es/asp/908.asp

As far as what is best to do, that's open for debate. I personally use
something simliar to the example above. Some people swear by on-the-fly
modifications like this, and others like to do it the hard way. I have no
problem using online mods like this for a site that is using Access, because you know that it's not going to be a crazy-busy site or anything.

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:OZ**************@TK2MSFTNGP09.phx.gbl...

What is the best way to create new queries and/or modify existing tables
within an online access database. At the moment, I am periodically
downloading the db and making alterations.

But, I have heard others on the list say they use a query analayzer

built on

a <form> where they execute SQL statements....

Is this the correct way to go?

- Jason