Database Question

Maximus_Primal · Post by **Maximus_Primal** » Tue Jul 12, 2005 7:57 pm

I want to create a program for collecting some items I have. Originally I was going to create my own basic database files but after leaving the program alone for 6 months (to do other projects) I have returned to realise I have no idea what the hell I was up to!

So my idea is now to create 2 database files (one for base information that is only read, and one for sotring items I have) and modify the latter in PB as required. I have acess to Microsoft Office at work so I can create the databases in Microsoft Access if that is any good. I want to keep the interface code as that still feels good, but just alter the database side of things to something more sensible...

Can anyone give me an idea of if this is a good way of doing it and if so any good examples of accessing and modifying Microsoft Access databases in PB. If this is not the best way of doing things, can someone suggest some ideas of how to do this with minimum fuss.

Thanks

Max

ABBKlaus · Post by **ABBKlaus** » Tue Jul 12, 2005 8:21 pm

Hi @Maximus_Primal ,

a good place to search for SQL examples is the purearea at http://www.purearea.net

Paul · Post by **Paul** » Tue Jul 12, 2005 8:30 pm

MDB_Lib from http://www.pureproject.net is a great place to start. It allows you to easily create MDB databases and has example code that creates/opens/builds tables/puts data in tables/searches

By the way, MDB (MS Access databases) can be created on any Windows platform. The ODBC drives ship with Windows. Programs like Office or Access are not required to use/create MDB databases.

Maximus_Primal · Post by **Maximus_Primal** » Tue Jul 12, 2005 9:28 pm

Thanks. I have downloaded the library mentioned and will take a look at it better this week. I see that it creates a database file in the example code so I am hoping that reading the database back into my code will be just as simple!

Thanks for the heads up on this.

Max