how to connect to hosted MS Access database @ godaddy

[jaybeegee66]

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