how to connect to hosted MS Access database @ godaddy

Hi!

We have an old website developed in classic ASP on a shared hosting plan @ Godaddy that uses an access database which is stored in a folder \access_db.

The website attracts very low traffic and a refresh is not on the cards in the immediate term.

I understand Godaddy offers MS SQL or MySQL db support but not MS Access and it would be too much work to upgrade the local vb6 application which also works off a MS Access database.

We currently FTP a copy of the database (ie. full not incremental) on a daily basis however randomly and we suspect it is because the site is being used it goes down most likely due to the database locked/in use.

Instead of closing the DB connection and showing a temporary landing page 'under maintenance' until we have the database uploaded we are investing how we can connect to the database to insert the new rows which is the preferred option but stuck! Any ideas please if there is an option?

cheers

Jay

Quote:

---

Originally Posted by jaybeegee66

... how we can connect to the database to insert the new rows which is the preferred option but stuck!

---

It kind of depends, how you currently handle these "Inserts" in your normal Desktop-App.

What I mean is, whether you're using "String-Concats" of the form:
Cnn.Execute "Insert Into SomeTable(ID, SomeField,...) Values(...,...,...)"

...or whether you currently use Rs.Update or Rs.UpdateBatch in your App
(to do your DB-changes).

In the end, you will not "connect directly from the clientside" to your DB on the WebServer.
You will have to go "through an *.asp Script instead" ... which will then contain VBScript-Functions which:
- create a serverside, temporary Cnn-Object against the serverside located "local DB"
- and then does either a serverside Cnn.Execute (on the String you passed along into that script)
- or alternatively you do an Rs.UpdateBatch call, to change the DB-state (after you uploaded the Rs, which contains the changes)

HTH

Olaf

thank you - that does help indeed as it gives some ideas. So we will upload a db containing the records to insert and see how to figure out a way to insert the records. appreciate you taking the time to respond. br
jay