Solved

Script for searchable database (Access)?

Posted on 1998-12-17
15
283 Views
Last Modified: 2013-12-25
Hi!  I need a good cgi script (or perhaps something else?) to enable users to search an Access database from a web site.  (I'm designing the web site.)  I understand the beta version of Office 2000 enables this process, but I'm wondering if there's another way... by the way, the database is 20,000 entries (but only about 3 columns).  Thanks!  Carol Clark
0
Comment
Question by:CarolClark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
15 Comments
 
LVL 6

Expert Comment

by:PBall
ID: 1857376
Please specify what scripting language? ASP? PERL? something else?

Or are you also considering client-side data-binded pages?

0
 

Author Comment

by:CarolClark
ID: 1857377
Well, looks like I'm already over my head again.  I have a little experience with cgi/perl but not with asp... and I've never heard of client-side data-binded pages.  So... although I thought it would be a matter of simply plugging in a cgi/perl script, it may be a much bigger project?  If so, PBall, what would you charge to engineer this for me?

Thanks.

Carol
0
 

Expert Comment

by:dhinckle
ID: 1857378
Carol,

What do you need for this script to do? I may be able to help you out.

DLH
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:dhinckle
ID: 1857379
I can't chew gum and think at the same time...

I'll rephrase the question: What do you need this script to do?

LOL

David
0
 

Author Comment

by:CarolClark
ID: 1857380
David,

Here's how I would like this to look, from the user's point of view:  Web site has a search blank and button.  User types in, e.g., "red" and the script searches for everything in the database that has "red" in it, then puts up a page with a listing of all the "red" items.  If we can get a little fancier, I'd like the user to be able to click on, say, the third item on the list and have that line of info be inserted into an e-mail to the site owner so the user can order that particular item.  (We're not going to do credit cards yet, but the site owner wants people to order items through e-mail.)

Carol
0
 

Expert Comment

by:dhinckle
ID: 1857381
I can't chew gum and think at the same time...

I'll rephrase the question: What do you need this script to do?

LOL

David
0
 

Expert Comment

by:dhinckle
ID: 1857382
Carol,

Are you running your own NT server or is someone else hosting the database?

How will the database be maintained? If updating from a browser (records added, deleted, edited), will images/pictures be required?

Can you provide a complete description of the database, including field names? Also will need to know the fields you want to search on and how you want to search them...

You might want to email this stuff to me...

David

hinckle@swbell.net
0
 
LVL 4

Expert Comment

by:mcix
ID: 1857383
Carol,

If David is unable to help you, please let us know...

Mc!IX
0
 

Author Comment

by:CarolClark
ID: 1857384
Thanks, mcix (Mc!|X?)... David and I are slinging emails back and forth, trying to get this nailed down... when we come up with a solution (assuming we do), I'll post the overview here... and I'll keep you in mind if he and I can't resolve this... thanks again...

Carol
0
 
LVL 4

Expert Comment

by:raoool
ID: 1857385
Likewise.. good luck. If you need an alternative and...

If you're hosting you're own NT server (or want to host with a provider that allows NT CGIs such as dev-com.com), can provide a simple CGI executable <$150>  that provides search of a FoxPro DBF file (easily exportable from Access); returns list of found records as links to individual records formatted as you'd like. Simple application/all setups and things accomplished in the HTML files. <see www.balancedcare.com/locations/bcclocator.htm as an example -- this looks up records based on state and/or services.

Raoool
0
 

Author Comment

by:CarolClark
ID: 1857386
Thanks, Raoool... I'll keep it in mind...

I'll be back later with more info...

Carol
0
 

Accepted Solution

by:
AnitaP earned 100 total points
ID: 1857387
Hi, I you need help I can be helpful. I am a web page developper and designer. I work for an internet provider and create web pages from A-Z. I can help you for FREE if you like. My services are volunteer work. I have designed this http://www.fantaisie.com site (which is a lingeray site only) it was all done with ASP. I have created the shopping basket from 0. I can help you if you need any help. You can also email me at

agwebdesign@yahoo.com

0
 

Author Comment

by:CarolClark
ID: 1857388
Thank you all... I would like to close the question at this time because, as it turns out, my ISP will be able to do the searchable database plus an auction.  It was easier (and probably less expensive) to sub out that part of the contract to them rather than for me to reinvent the wheel.

My understanding is that they'll use a SQL server to manage this... but I still don't know the fine points...

Thanks!

Carol
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 1857389
I suggest a quick lesson in ASP... run down to your local tech book store and get a good book on building ASP sites.   Everything you ask can be done with a few simple ASP scripts, I know... ;-)
0
 

Author Comment

by:CarolClark
ID: 1857390
I have this site up and running now.  Check it out at www.goldengaterecords.com.  I worked with a programmer at my ISP and I believe he used mostly cgi/Perl to accomplish the backend data crunching.  I'd appreciate any comments people might have--email me at carol@cdclark.com.

Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Convert Silverlight ERP To Angularjs,HTML5 3 107
WordPress 8 69
Unexpected End of File 11 85
type of website 13 51
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question