Web Database
in [Tables]
|
From: John W. Vinson on 12 Feb 2010 21:51 On Fri, 12 Feb 2010 14:34:03 -0800, George <George(a)discussions.microsoft.com> 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]
From: Daniel Pineault on 12 Feb 2010 23:33 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 <George(a)discussions.microsoft.com> > 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] > . >
From: David W. Fenton on 13 Feb 2010 18:34 John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in news:pg4cn5pdi361ha4lnhudik5ffn8l2nu5om(a)4ax.com: > 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/
From: David W. Fenton on 13 Feb 2010 18:37
=?Utf-8?B?RGFuaWVsIFBpbmVhdWx0?= <DanielPineault(a)discussions.microsoft.com> wrote in news:2D4244C7-CC76-4F30-979F-F38392D779E0(a)microsoft.com: > 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/ |