Hi,
I've converted the tables from an old Access application to MySql format. I
then linked the tables into access using MyODBC and everything works great
(on my computer). For now, I want to keep Access as a front end, and move
the tables to the Internet. I feel like I'm lost in a maze or something with
some really basic questions.
What do I need in terms of a host? I have been looking at ipowerweb because
they have a reseller program and that is something that I am potentially
interested in. I am also looking at the hosting services provided by
mysql.com. I'm pretty sure they have what I need, if only I knew what to ask
for!
Also, for this first app, there is only one database, but there are a number
of users. I don't understand the security setup. Do these people need to be
"users", as in the way you setup users on a web page? Or, do I just have to
setup users in MySql?
I hope that was clear. Here is what I want:
1) I need to know who to get in terms of an ISP. If they have a reseller
agreement, that's a plus.
2) Assume I find that ISP and get an account that allows for, say, five
"users". Does that have anything at all to do with who and how many people
can access and use the database?
3) Beyond all of this, I'm a bit lost in trying to get a handle on the big
picture of what tools I need to administer these databases, to create forms,
etc. It seems that phpmyadmin will not run on my windoze xp computer no
matter what I click. Also, must I learn php or whatever in order to create a
database? Or is there some product out there that will let me concentrate on
the visual design and generate queries and forms and so forth, ala Access?
Thanks!
Daven