sql statement on MDB

L

Lurc

Hi all,

Are there any preferred freeware or shareware which can support simple sql
statement for ACCESS MDB?

Thanks.
 
T

Tom Wickerath

Lurc,

Please clarify your question. What is it that you are looking for? It
sounds like you might be looking for an application that provides similar
functionality to the Query designer within Access (?), although I'm only
guessing.

Tom
________________________________________

:

Hi all,

Are there any preferred freeware or shareware which can support simple sql
statement for ACCESS MDB?

Thanks.
 
J

John Vinson

Hi all,

Are there any preferred freeware or shareware which can support simple sql
statement for ACCESS MDB?

Thanks.
Click to expand...

Access supports SQL statements (in the somewhat idiosyncratic JET
dialect of SQL) natively; recent versions have an option to support
ANSI 92 SQL. Create a new Query; click VIEW/SQL; you've got a SQL free
text window with SELECT; in it, which you can edit to your heart's
content.

What are you looking for that Access does not already provide?


John W. Vinson[MVP]
 
L

Lurc

Thanks Tom & John.

I am now using Access 2000, and want to run some sql statements for query,
but cannot find a proper way to do. So is there any built-in tool for it or
should I find a 3rd party utility?
 
T

Tom Wickerath

Hi RL,

Is there a reason that you cannot simply save the query in Access 2000 and
run it from there? What type of SQL statements do you want to run (for
example, SELECT, UPDATE, INSERT or DELETE)? Are you wanting to run your SQL
statements in a VBA procedure? Please give a detailed example of what it is
that you are attempting to do.

Tom
_____________________________________

:

Thanks Tom & John.

I am now using Access 2000, and want to run some sql statements for query,
but cannot find a proper way to do. So is there any built-in tool for it or
should I find a 3rd party utility?
 
L

Lurc

Hi Tom,

We have a very old system along with our attendance controller, which uses
Access 97 as its database.

Now we want to do a 2nd development using VB.NET, (and my default .MDB
reader is Office 2000). After checking its structure cannot be modified,
otherwise the original program cannot work any more.

So I want to use a standalone utility to operate that Access97 MDB and run
sql, mostly are select statements, before coding in .NET.
 
T

Tom Wickerath

Hi RL,

You should still be able to use your copy of Access 2000 to run queries in
this Access 97 database, without modifying the original database in any way.
Create a new database in Access 2000. Then use File > Get External Date >
Link Tables... to link to one or more tables in the existing Access 97 .mdb
file. You can then create queries in Access 2000 against the linked tables,
as though they were local tables. You can use the default QBE (Query by
Example) grid, or if you're feeling really adventurous, you can switch to SQL
View and write the SQL statements directly. Once you have a query working
properly, you can switch to SQL View, copy the SQL Statement, and paste it
into your VB.Net app. For the most part, it should work as written. You'll
have to make slight adjustments for any variables that you wish to use as
criteria, but that's no different from pasting the SQL statement into a new
VBA procedure.


Tom
____________________________________

:

Hi Tom,

We have a very old system along with our attendance controller, which uses
Access 97 as its database.

Now we want to do a 2nd development using VB.NET, (and my default .MDB
reader is Office 2000). After checking its structure cannot be modified,
otherwise the original program cannot work any more.

So I want to use a standalone utility to operate that Access97 MDB and run
sql, mostly are select statements, before coding in .NET.
 
Top