Access an a form in .mdb from the web

  • Thread starter Thread starter GenesisVF
  • Start date Start date
G

GenesisVF

Hello All,
This has been breaking my nerves for some time now.

I have an .mdb file that has a form. The form has three inputs:
1) a FROM_date field
2) a TO_date field
and
3) a Source field

When I open the access file, I prompt the user to input the FROM and
TO dates and also the SOURCE filed.

When the user presses the button GO, my code runs a macro, that is
triggering a couple of SQL queries to run on an Oracle database. The
results are stored on a table, and then displayed to the user.

How can I do the same procedure from the web?

For example, I will give the users my web servers address, the same
form will come up. They will input the data as they do with the .mdb
file, and when the queries are done, they get the results in explorer.

Is this possible?

Thanks
 
Hello All,
This has been breaking my nerves for some time now.

I have an .mdb file that has a form. The form has three inputs:
1) a FROM_date field
2) a TO_date field
and
3) a Source field

When I open the access file, I prompt the user to input the FROM and
TO dates and also the SOURCE filed.

When the user presses the button GO, my code runs a macro, that is
triggering a couple of SQL queries to run on an Oracle database. The
results are stored on a table, and then displayed to the user.

How can I do the same procedure from the web?

For example, I will give the users my web servers address, the same
form will come up. They will input the data as they do with the .mdb
file, and when the queries are done, they get the results in explorer.

Is this possible?

Thanks
Click to expand...

Anyone? :(
 
If you create a JSP page on your Oracle server to update the table then you
can link into it from your page on the Web server.

John
##################################
Don't Print - Save trees
 
Back
Top