CGI and searching an Access DB

For the time being my question is quite easy. I want to use form information from my HTML to search an Access DB located on my own server, and then return the findings to my web page. My problem is that I'm just generally vague in this whole area. I need to know things like: is Access the best medium in which to keep my data? / I am thinking of using VB to search the DB, is this the best method to use? etc. If anyone can point me in the right direction and give me some tips, then that would be great. I know I could research this myself, but time is an issue, and I want to know that at least I'm on the right path before I seriously look into it.

Who is Participating?
jcondeConnect With a Mentor Commented:
Hi nsmith.

First, Access is good enough if you have a "small" ammount of records or information in your database.  With small I mean less than 300,000 records TOPS!

Now, since access is a SQL powered DBM, you don't really need VB to access the database!  All you need to do is create a ODBC and work from there.  Using VB will just  make everything much more complicated and less efficient!  why not install Cold Fusion in your web server?

Cold Fusion is a HTML code extender used primarily to access and display database information in a web page....for example...
Pretend you want to display in a web page table all the records in a database table.  The code would be the following  (In your HTML page)



I really recomend you try Cold Fusion out......It's Great!
A Trial version of cold  fusion can be found at:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.