After searching the forums, I've caught glimpses of this, but I'm not sure I've found an answer...

Is there software (Like MS Access or MySQL) that will allow me to upload/delete/edit data from my computer to a MySQL database on a remote server? I would perfer to do this in Access, as I know how to use that software, but I'm more than willing to try out new things.

Thanks,

Andrew

there is this or do a Google search for "MySQL GUI" (no quotes)

Thanks...

I downloaded and installed. I was then told, however, that GoDaddy, my host, does not support the software. When I inquired further, tech. support told me that they do not support any software that would allow me to edit mySQL databases outside of their interface. (I think they use PHPADMIN)

Does this sound right? Does that suck, or what?

Andrew

Why can't you just use PHPMyAdmin ?

And yeah it sounds right, not all servers want GUI, it can cause security risks - especially when you're as huge as GoDaddy.com

If you can export from access or excel into Comma Separated Value format then you can use phpMyAdmin to import that data into a file.

Thanks.

I'd like to use PhpAdmin, but I was hoping to automate the process, as this database will be updated as much as six times a day. If I can set up a computer to automatically update the mySQL database every 2-4 hours, it would be perfect.

What do you think? Can I automate with PhpAdmin?

A quick solution that I came up with: I can program a Visual Basic routine that copies a file to the server...Why not just store the information in a flatfile? Then, the info can be updated and copied to the server. The old file can be deleted, and replaced. Security isn't really a concern, as this is public information anyway.

Andrew

You could write a php script to do the updating, leave that on the server, and then write something that will hit the server with an HTTP request, passing the data along as a post variable?

could use a cron job to execute the script too.

Are there any threads or web pages that discuss either of these solutions? I must admit, I don't know how to do either.

Andrew