Microsoft Access Databases

[Ronald Weber Member Find all posts View Profile Close Ronald Weber]

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

[Jim Huguley Member Find all posts View Profile Close Jim Huguley]

Ronald..

Visit http://perfectsync.com/DevelopmentTools.htm

Check out SQL Tools...

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


------------------
Jim..
[email protected]

[Matthew Berg Member Find all posts View Profile Close Matthew Berg]

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).]

[Eric Pearson Member Find all posts View Profile Close Eric Pearson]

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_Init
    SQL_OpenDB "MyData.DSN"

For more information, here is a direct link to our SQL Tools page...

http://perfectsync.com/sqltools.htm

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 microsoft.com.

-- Eric


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