We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

CGI and MSAccess

varname
varname asked
on
Medium Priority
196 Views
Last Modified: 2013-12-25
I am setting up a Website that will have a form webpage that the data will be submitted to a MSAccess db, then run some VB functions on the database, then call another program to use the output to create a new .dxf file to view on their browser(or download to their disk), can you give me an outline of such a script in Visual Basic(we have a VB programmer on site)?
Comment
Watch Question

Commented:
When a form is submitted the form 'action' will be to call the VB program. All of the form data will then be available to the VB program to do with as it wishes.

The VB program should verify the data received and output an HTML document (to stdout) which it generates depending upon the action it is taking (e.g. report any errors in the data or confirm that the data has been accepted) as well as updating the database.

If you are creating another .dxf file then presumably you will need to create HTML links to it. I assume that this will require modification to an 'index' html file which has the URL to each database file. The VB script will need to modify this file as well by adding the new link.

I suggest that you should create 'dummy' html documents which show how the generated HTML should look. e.g. one for a typical error condition, one for the confirmation that the database has been updated. Check that the HTML is correct first (e.g. the links work and the layout is correct) and then use these 'templates' as part of the specification for the VB programmer.

There are likely to be standard library routines that allow a VB program to access the form data and make your VB programmers job easier. Look for something like 'cgi lib' although they are not difficult to write.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.