Need advice before embarking on VBA code

[barleybill]

Hello
I need to add some functionality to my website that uses access 2003. I suspect that this can be done in VBA but want to ensure that it is practical before starting to learn a new language.
The whole process would be:-
There is a server to server transfer into my website, currently an ASP page with post, but this can be changed.
The data in the post needs to go into the access database and I have this already functional..
Depending on the data values in the post, a further URL with an ASP page is selected and processed on the server before being sent to the customers browser.
I have the URLS already in the access tables as hyperlinks and they work by double clicking them but no post has been added yet.
My questions are:-
How to trigger the hyperlink, do you use follow hyperlink in some code somewhere?
Can the trigger come from data being loaded into one cell of the tables, or can it be triggered from the incoming ASP page? via ADO?
How do you get post into the ASP page using an access hyperlink?
I would really like to know if this can be made to work reliably before dedicating hundreds of hours to it.

barleybill

 

[Simon_MT]

This is what I use either into ASP or ASP.Net, the varability is the Exhibition, OE is ised for paging.

Function Web_ExhibitionsOriginals()
    With CodeContextObject
    Dim WebLink As String
        WebLink = GetWebPath & "Originals_Exhibitions.aspx?Exhibition=" & .[Exhibition] & "&OE=1" & ""
        Application.FollowHyperlink WebLink, , True
        HideWebToolBar
    End With
End Function

Simon

 

[barleybill]

Thanks, Simon. That can forward from the ASP page but I need to pass through the access database. There are security problems with simply forwarding from within the ASP page and later operations fail. I want to kick off a new process from within access in order to strip away the security problems.


barleybill