Avatar of JPD153
JPD153
Flag for United States of America asked on

Web creation tool

I need to create a web site on a local server Win 2008 R2 (not hosted externally) where people can make a simple query on one single field to an Access or SQL express Database which is updated infrequently by only one user.
I do not do web site development and I need a tool that is easy to manage to create and maintain that site
Suggestions welcome
Web ApplicationsMicrosoft IIS Web ServerWeb Development Software

Avatar of undefined
Last Comment
JPD153

8/22/2022 - Mon
Walter Ritzel

I think the easiest thing to do is to use ASP.NET wizards to build the forms for the basic operations.
JPD153

ASKER
Never used it. No idea what to do with it and where to find it
Walter Ritzel

To start, visit http://www.asp.net
There, you'll find everything you need to start with it.
If you dont want to start from scratch, look for something called DotNetNuke (http://www.dnnsoftware.com/). Maybe this will help you.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Big Monty

I think .NET, for something like this, would be overkill and if you're not familiar with object-oriented development, it could be a steep learning curve.

if you're only going to access one field in one table, you may want to just go with a MS Access database, and put it up on a network share so everyone internally can look at it. From there, you could easily set up a form directly in MS Access and tie it to your table.

if this is a path you want to explore, let us know and we can get you the info you need to get started

A third option would be to contract this out to someone here on EE by using the "Hire an Expert" feature, I'm sure someone could whip it up for you relatively quickly.
JPD153

ASKER
Internally people have already access to the whole Access DB. The issue osfor external people who need to find multiple informations from multiple tables by typing in just one piece of data (a PO #)
JPD153

ASKER
I've requested that this question be deleted for the following reason:

no practical answers provided
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Big Monty

The issue osfor external people who need to find multiple informations from multiple tables by typing in just one piece of data (a PO #)

this is exactly the opposite of what you said in your original post. you said it's a query on a single field NOT for external use.

there were several good ideas presented to you, just because you didn't like them doesn't make them impractical. there are no "tools" to help you create a custom piece of logic for your database, that is what programming is for. The closest you'll get is the Forms Builder from within access:

https://www.youtube.com/watch?v=Rj0ZBLlbsRc
http://www.access-programmers.com/creating-a-new-form-in-design-view.aspx
Big Monty

see my comment for my reason
Walter Ritzel

If you need to build something (as you imply on your question), but dont have the skills, I think DotNetNuke is the practical answer you are looking for: (http://www.dnnsoftware.com/).
The only knowledge you need is to make sure DNN requirements will be met on the local server you mention.

Also, make this available to external, which was not mentioned on the original question, independs of this.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
JPD153

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.