473,320 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

HELP! -- Trying to put up first database

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
Jul 20 '05 #1
2 1668
I'm not shure what you asking.
Are your shure you can connect to a on-line MySQL database with your Access
application?
I mean, if you're not shure, maybe it woun't even work.

But if it works...
You need 5 users on 1 database with serveral tables.
(I think this is what your are saying in your discription).

If you explain what the users can do and cannot and what tables they need to
access, maybe that helps.
I think my provider www.sohosted.com provides this (but you can even use
your Access database if you want) from about $2,- (excl. 19% taxes = 1.50
euros) per month.
But you first need to explain (aso for yourself), what each user needs.

wouter


"Daven Thrice" <da*********@NOyahooSPAM.com> wrote in message
news:Kgrod.126304$cJ3.52641@fed1read06...
: 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
:
:
Jul 20 '05 #2

"Wouter" <no******************@djwice.com> wrote in message
news:cn**********@news.tudelft.nl...
I'm not shure what you asking.
Are your shure you can connect to a on-line MySQL database with your
Access
application?
I mean, if you're not shure, maybe it woun't even work.
Wouter,

I can connect Access to MySQL using MyODBC. Actually, there's quit a bit of
documentation of how to do this on mysql.com. I have the database connecting
here on my computer, so I think it is just a matter of getting the database
online and then connecting to the tables via ODBC.

But if it works...
You need 5 users on 1 database with serveral tables.
(I think this is what your are saying in your discription).

If you explain what the users can do and cannot and what tables they need
to
access, maybe that helps.
They would need to be able to use the database, for example, edit and view
data in forms, pull reports, etc. They would not need to administer the
database. I will administer the database myself, I assume using phpmyadmin
on the server, or other tools for whatever I do on my computer.
I think my provider www.sohosted.com provides this (but you can even use
your Access database if you want) from about $2,- (excl. 19% taxes = 1.50
euros) per month.
I think that in order to use an Access database online, you can't use the
Jet Engine. There are some basic ASP forms you can generate using Access,
and combined with FrontPage extensions there is some limited functionality.
For the most part, you have to move your tables to SQL or something like
that, as I am doing. I'll bet that they are suggesting something like what I
am doing, which is using an Access front end and using MySQL for the data on
the server.
But you first need to explain (aso for yourself), what each user needs.


For myself, I need to create, change and maintain all aspects of the
database as related to development and maintenance. The users will simply be
users of the database, meaning that they would need to read and write data
through forms and pull reports.

Thanks!!

Daven
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an rtf file created in word. I used the Help...
9
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu item. Also, I've got a compiled file made with...
4
by: Sarir Khamsi | last post by:
Is there a way to get help the way you get it from the Python interpreter (eg, 'help(dir)' gives help on the 'dir' command) in the module cmd.Cmd? I know how to add commands and help text to...
2
by: Sudheer Kareem | last post by:
Dear All Please tell me how to assosiate help files with my Vb.net Project. Regards Sudheer
6
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have do a test program, but I have no correct doing...
6
by: d.warnermurray | last post by:
I am doing a project for school that involves creating help files for a html authoring tool. If you could help me with answers to some questions it would really help. 1. What tasks do you expect...
3
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> With...
4
by: dixie | last post by:
Help, I'm really out of my depth here (not unusual I hear you say :-). I have just installed HTML Help in an application. I told it in the Project Properties the path to the help file. I then...
5
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to access this help file during his development time...
1
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="9B7D5ADD-D8FE-4819-A36C-6DEDAF088CC7"' 'UPGRADE_WARNING: Couldn't resolve...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.