Web Database

  • Thread starter Thread starter George
  • Start date Start date
G

George

I am looking to create a web database for my web site. My web host provides
My SQL, can I use a Access database to store the data. Where can I find the
steps to create a web database - my host provider isn't very helpful. They
provide MySQL and Php MyAdmin.

Where do I begin ?

Thanks
 
If your host provides MySQL and PHP then you start to learn those 2 tools or
switch to another host. That said, MS Access is not geared towards
developing web based application with the exception of SharePoint...., but
that will not be part of a hosting plan anyways. Short answer, if you wish
to truly develop a web app., then start learning MySQL and PHP. There are
numerous free ressources to do so.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Daniel - I understand you can't use Access to create a web database, but I
noticed on my host provider has a feature to upload a Access database and
covert it to SQL rather then creating a table within their SQL from scratch,
does that sound possible ?
 
Upsizing to Sql Server is one option.

If you do not already have a db created, then simply start with the tools
they give you. If you already have the table structure/data, then it would
be worth the transfer process to save you time.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Yes it does - thank you for your time...

George

Daniel Pineault said:
Upsizing to Sql Server is one option.

If you do not already have a db created, then simply start with the tools
they give you. If you already have the table structure/data, then it would
be worth the transfer process to save you time.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
Click to expand...
 
Daniel - I understand you can't use Access to create a web database, but I
noticed on my host provider has a feature to upload a Access database and
covert it to SQL rather then creating a table within their SQL from scratch,
does that sound possible ?
Click to expand...

MySQL and Microsoft SQL/Server are two *different programs* (competitors, in
fact). Don't confuse them with one another!

But yes, it's possible to upsize an Access database to either. Not trivial but
possible. I'd be inclined to learn enough MySQL (if that's what your provider
supports) to create the table, properly normalized with indexes and so on; you
will then be able to use an ODBC connection from your Access database to your
new MySQL database, and run Append queries to migrate your data into MySQL. If
you are working with SQL/Server there are Microsoft upsizing tools to do so -
take a look in the microsoft.public.access.sqlupsizing newsgroup for detailed
discussions.
 
A little addition to John's post.

He is very right that it is possible to remotely, using odbc, connect to a
web db. That said, before counting on this approach, you need to verify with
your host if they allow such remote connections. Many do not for security
reasons. In which case you would need to look into alternate approaches.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
But yes, it's possible to upsize an Access database to either. Not
trivial but possible. I'd be inclined to learn enough MySQL (if
that's what your provider supports) to create the table, properly
normalized with indexes and so on; you will then be able to use an
ODBC connection from your Access database to your new MySQL
database, and run Append queries to migrate your data into MySQL.
If you are working with SQL/Server there are Microsoft upsizing
tools to do so - take a look in the
microsoft.public.access.sqlupsizing newsgroup for detailed
discussions.
Click to expand...

If you have an existing DSN defined for your MySQL database, you can
just export the table to the DSN, and it will all be converted for
you by the ODBC driver, including the data.
 
=?Utf-8?B?RGFuaWVsIFBpbmVhdWx0?=
He is very right that it is possible to remotely, using odbc,
connect to a web db. That said, before counting on this approach,
you need to verify with your host if they allow such remote
connections. Many do not for security reasons. In which case you
would need to look into alternate approaches.
Click to expand...

One alternate approach (which I use all the time) is to install a
local installation of MySQL and phpMyAdmin. If you create a DSN for
your MySQL database (even if it has not tables in it), you can then
export your Access tables to that DSN (ODBC is one of the export
options). Once you've got the local MySQL, you can then use
phpMyAdmin EXPORT to write a script that you can then upload to your
server and run there. Most ISPs provide phpMyAdmin as the interface
for MySQL, so it's pretty easy to do. If they don't, you can
probably install it yourself (it's not that difficult).
 
Back
Top