No announcement yet.

Microsoft Access Databases

  • Filter
  • Time
  • Show
Clear All
new posts

  • Microsoft Access Databases

    It is possible to connect to MS Access databases via PBDLL 6.0?

    Also, can I perform SQL type searches using PowerTree as with MS Access?

    Any suggestions would be greatly appreciated.

    Thanks, Ron

  • #2



    Check out SQL Tools...

    PowerTree is a BTree indexing tool used with flat files, not a database manager per se.

    [email protected]


    • #3
      you may also find this thread useful: sqltools and odbc driver distribution. although he doesn't say it on his web site, i think eric has come to the conclusion that the access odbc files come with all micro$oft 32-bit windows except windows 95.

      [this message has been edited by matthew berg (edited march 09, 2000).]
      If you try to make something idiot-proof, someone will invent a better idiot.


      • #4
        Thanks for the "plugs" Jim and Matthew!

        Ron, it is possible to use an Access database with pure PB/DLL code if you're willing to spend a lot of time figuring out the necessary ODBC/SQL API functions. But I doubt that you'll find anybody who has actually done it who will say that it was easy. Or fun.

        My company's SQL Tools package encapsulates the entire process, so (for example) instead of using dozens of lines of code and nine different API functions, you can open an Access database with just two very simple lines of PowerBASIC code...

            SQL_OpenDB "MyData.DSN"
        For more information, here is a direct link to our SQL Tools page...

        There is also an independent review of SQL Tools there, from a recent issue of the BASICally Speaking newsletter.

        As Matthew pointed out, the Access ODBC drivers that you'll need are available on your Windows 98/NT/2000 CD, or if you're using Windows 95 you can download a free driver package from

        -- Eric

        Perfect Sync: Perfect Sync Development Tools
        Email: mailto:[email protected][email protected]</A>

        "Not my circus, not my monkeys."