How to use accessfile in my HTML webpage

lvermeersch · Joined: 25 Aug 2005 Posts: 13

I want to use a simple access mdb file in my HTML page.
I want to handle it through vbscript (or maybe java)
I probably need a control or activeX?
What is the best to advice i should use. Probably the provider's server should support this control.
I have in the past tried a vb6 control ADODC control but didn't succeed in changing a record, could only read the records.
There is mayby allso an Micr Office data source control activex, is that any good? I am novice in databases implementation in HTML.
I did use simple control like Tabular data control for reading records from a text file, this works simple and great, if some knows a better control for this allso would be great.
On other thing maybe a code example on how to use the control in a script and maybe allso to connect with a form so the form is a record that is added to the database after sending, if possible.

webmaster

I don't know anything about using access databases, but I do know that it's possible to use ASP+Access and I think that's the best way to connect the access database to your webpage, does your server have support for ASP?

And welcome to DEVPPL.

lvermeersch · Joined: 25 Aug 2005 Posts: 13

I would have to ask about the ASP support on the server but anyway if i have to use ASP i will have to abondon it, sadly asp is no option for me. It should be done in HTML through an object control or activex or something.
I hope to find something soon

webmaster

I don't think there is any system like that for html, it would be very unsecure.

lvermeersch · Joined: 25 Aug 2005 Posts: 13

I did try the Adodc control once more.
I did menage to change a field from the recordset with a vbscript
but this only is changed while the webpage is open, so it's not really saved into the .mdb databasefile. Hum could this be a securityproblem like , or maybe a lower securityoption setting in the IE browser could this change annything?

I allso did bound a text field with the DataSrc ans DataFld attibute and the tablevalue is filled in, now when the user makes a change in that field I want to save this to the mdb databasefile, or maybe should this be done by sending a bound form or something.

webmaster

I don't know anything about vb or directx programming so unfortunally, I can't help you with this Sad