inserting rows into database - no access installed

darrenallen · 5 Apr 2007 at 20:44

This is probably an odd request but I will do my best to explain.
In work I need to develop webpage to transfer some data to a database (insert a new row on the database with this data) but the users do not have microsoft access installed.
They do not need to pull back any data, just insert new data into the database.
I know how to create the appropriate form on the web page but is it possible to transfer the fields to a database if they don't have Microsoft Access installed. It has to be Access as our works only use this.
An initial starting point would be great, if it is possible.
Any help would be grateful.

darrenallen · 5 Apr 2007 at 20:57

Thats the way I have it running at the moment.
Just thought it would be better to have the data sent to the database direct.
Forgot to mention that there are multiple users.
It would literally be a case of a sending fields to eg. field1, field2, field3..... to the database as a new row. One of my colleagues was about to start work on it but left the company before he started, typical.

darrenallen · 6 Apr 2007 at 00:40

I looked at visual studio web developer but it far exceeds what I need. It looks to be more than I could cope with.
All im after is a simple web page with a few drop down boxes and then to send the results to a database, as a new row.
At the moment I have the same thing set up on an excel sheet that sends the results to a new row on another spreadsheet.
It would be easy enough if everyone in work had access installed but they won't pay for the license.
Doing the webpage is fine,already done, but getting it sent to a database is tricky. But i'm sure it can be one.

darrenallen · 7 Apr 2007 at 15:22

JimmyEatWorms, your solution is perfect, does the job exactly as I need.
You're a lifesaver, many thanks.

darrenallen · 7 Apr 2007 at 17:27

I spoke too soon.
The route JimmyEatWorms links to is the right thing for my purpose but the users will not have a Personal Web Server or IIS installed.
The code seems right, but is there a way to put this into javascript or vbscript on a single webpage and still keep the functionality there.
I'll submit any code that i've done but effectively it is a form on a webpage that needs the data sent to a database stored on a shared drive. The users will not have any sort of database software installed on their machines.
Sorry for taxing you further.

darrenallen · 7 Apr 2007 at 23:12

I've finally got there but i've got stuck on such a stupid point I feel embarressed to ask.
My code is currently, as a javascript sub is:

var adoConn = new ActiveXObject("ADODB.Connection");
var adoRS = new ActiveXObject("ADODB.Recordset");
adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/a/tblTest.mdb");
adoRS.Open("Select * From tblTest", adoConn, 1, 3);
adoRS.AddNew;

It does everything I need i.e. updating the database with the required information but as it stands the datasource path relates to a database held on the root of the "C" drive. I've tried to change the entry from '/tbltest.mdb' to another drive and I cannot get the correct format for the string.

How do I get it to look at a specific drive/directory for the database??

darrenallen · 8 Apr 2007 at 10:03

Thanks for the advice but it is probably easier for me to make sure the database is located on the same shared drive as the webpage. This will probably solve my last issue.
Thanks all the same.