A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Web Database



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2010, 09:20 PM posted to microsoft.public.access.tablesdbdesign
George
external usenet poster
 
Posts: 883
Default 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  
Old February 12th, 2010, 11:00 PM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old February 12th, 2010, 11:34 PM posted to microsoft.public.access.tablesdbdesign
George
external usenet poster
 
Posts: 883
Default 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  
Old February 13th, 2010, 12:23 AM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old February 13th, 2010, 12:28 AM posted to microsoft.public.access.tablesdbdesign
George
external usenet poster
 
Posts: 883
Default 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  
Old February 13th, 2010, 03:51 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old February 13th, 2010, 05:33 AM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old February 14th, 2010, 12:34 AM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default 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  
Old February 14th, 2010, 12:37 AM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.