An access database on a website

[neillovell]

Hi all,
For the upcoming soccer season I'm thinking about keeping the stats for my fantasy team on a website, in a database. This got me thinking about Access and Excel - can you simply drop these onto a website and use them as you would if they were on your local computer? This is just a general Q as I can't do this just like that because some of my friends who would use the site don't have Access or Excel.
I've done some work using ASP to generate a webpage and write data to an access database, and retrieve it naturally, but I'm wondering if a MySQL-enabled website would be better. I suppose what I'm asking is which would be better to just hold and sort the records (because some users won't have access or excel).

 

[Zebbeddee]

You are using an ASP to get the data stored in and access data base so Access isn't managing the retrieval of data or the display (right) so it shouldn't matter whether your friends have Excel or Access the ASP should show them the data.
What is better?
Access is a pithy little program with a tiny memory storage capacity and a geuine pain.
however it is simple to use very manipulatable and useful if you don't have to store large amounts of data as it has a lot of built in features
Moving to a MySQL-enabled site would probably be a good idea but may not be nessecary.

Do you want your friends to be able to store the data on thier machines or just view it on your webpage.

Booiinnggg ... Zebbeddee ... Booiinnggg

 

[neillovell]

Boiinnng back at ya baby...

Anyway, I guess I can format it on the screen and the users can save it as HTML (or even XML) so that'll be find. This idea is early in conception right now (season starts mid august though!!!). So MySQL is bigger and betteR? Could be useful to move to that then.

Do you know any free web hosts with MySQL ?

 

[Zebbeddee]

NO

 

[Zebbeddee]

I guess I win the award for the shortest thread (see above)

No sorry I don't use MySQL on the internet.
Does anybody else know one?(free web hosts for MySQL).

Booiinnggg ... Zebbeddee ... Booiinnggg