If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Web Database
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 |
#2
|
|||
|
|||
Web Database
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. "George" wrote: 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 |
#3
|
|||
|
|||
Web Database
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 ? "Daniel Pineault" wrote: 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. "George" wrote: 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 |
#4
|
|||
|
|||
Web Database
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. "George" wrote: 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 ? "Daniel Pineault" wrote: 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. "George" wrote: 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 |
#5
|
|||
|
|||
Web Database
Yes it does - thank you for your time...
George "Daniel Pineault" wrote: 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. "George" wrote: 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 ? "Daniel Pineault" wrote: 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. "George" wrote: 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 |
#6
|
|||
|
|||
Web Database
On Fri, 12 Feb 2010 14:34:03 -0800, George
wrote: 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 ? 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. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Web Database
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. "John W. Vinson" wrote: On Fri, 12 Feb 2010 14:34:03 -0800, George wrote: 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 ? 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. -- John W. Vinson [MVP] . |
#8
|
|||
|
|||
Web Database
John W. Vinson wrote in
news 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. 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. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#9
|
|||
|
|||
Web Database
=?Utf-8?B?RGFuaWVsIFBpbmVhdWx0?=
wrote in : 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. 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). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|