Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Unanswered: SQL client to use against MS Access

    I'm looking for a SQL client that I can use via ODBC to access the data within my MS access DB. I have searched but cannot find one that uses ODBC. Has anyone got any recommendations ?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    SQL client in What?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2007
    Posts
    3
    what do you mean in what ? I'm looking for a client that can access any database using ODBC (specifically MS access for now). I had one a few years ago but cannot remember the name of it..aaargh

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ummm... MS Access?

    It might help if you elaborated on what you think a "Sql client" is and what it's used for.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Mar 2007
    Posts
    3
    ok i have lots of data in my MS access DB.

    Soon I will be porting the data to oracle

    In the mean time I want to be able to build and execute SQL scripts firstly against the MS access DB, then eventually after porting, run the same (or thereabouts) scripts against the oracle DB.

    I want a client that can execute SQL against the MS access DB, rather than storing the SQL in MS access itself

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Oracle doesn't use the same version of SQL as access. Your scripts will not execute the same on both platforms, if at all.

    You can use oracle to talk to access or access to talk to oracle, there is no need for a third party client.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    ...boring answer, I know, but A is a brilliant-ish front end and a middling (at best) database engine for more than one user.

    the startlingly obvious choice is A to attack an A(JET) database.

    i would also argue that A is a more than decent choice to attack just about any supported database engine.

    izy
    currently using SS 2008R2

  8. #8
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Query Express works fine with most databases. It was designed to work with SQL Server, Oracle, and OleDB (not ODBC.) I've used it with Access (OleDB), Oracle, and SQL Server.

    Ref this thread at a sister site for an OleDB connection string builder.
    Last edited by loquin; 03-21-07 at 17:23.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  9. #9
    Join Date
    Feb 2005
    Posts
    33
    Hi smckeown,

    I'm using Database Browser (Freeware from DB Software Laboratory, see http://www.dbsoftlab.com/download.php?view.14).
    It's not a great tool, but it works (and with odbc on an MS-Access file).

    Best regards
    ifx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •