Web host doesn't support access 2

[cammy]

Hi

I have spent ages plodding along creating a new website using asp/vbscript/access but have just discovered that our website host doesn't support access.

They support mySQL but I don't know anything about this or where to get it. I built the site using dreamweaver mx and access 2000

Does this mean I will have to redo all of the database stuff for the site using mySQL?

What is mySQL? Is it a program like access that I can build a database in?

Any help appreciated.

Cheers

Cam

 

[Wullie]

I phoned our host again to day to try and talk them into taking the access database but they reiterated that they no longer support it due to security issues (and that microsoft no longer support it).

Ask them what security issue there is from Access databases other than it being downloaded if it is in a web accessible directory. Even if that was the concern they have then that's for you to worry about, it is no threat to their system if someone else downloads your database.

Anyway, Access requires nothing extra to be installed on a Win2k3 server, everything you need for Access is already there. The only stumbling point would be the DSN, but you just need to start using DSNless connections.

How would I now go about this using a mySQL database - ie a visual way for them to update the database.

Eventually, I intend to build a web interface for doing this but at the moment I am limited in what I can do and the time I have to do it.

You may not be able to use a remote GUI, it really depends on how the host has everything configured. For example, we block all requests on port 3006 other than those originating on our network because it is much more secure. However, if your host does block these requests and if you have a static IP address, you could ask them to allow your IP to connect past the firewall.

Hope this helps

Wullie

Fresh Look - Quality Coldfusion/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[Wullie]

Forgot to mention, check if they have phpMyAdmin installed, you can use that for managing MySQL. If they don't have it installed, you could install it yourself on their server anyway.

Hope this helps

Wullie

Fresh Look - Quality Coldfusion/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[ChrisHunt]

and that microsoft no longer support it

They're lying to you - in a rather blatant and stupid way. A visit to the MS web site will reveal that Access is alive and well.

Time to change hosts to one who'll tell you the truth. If they're lying about this, what else aren't they being straight about?

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd