Doug Murphy
dw-murphy at cox.net
Thu Sep 27 18:09:12 CDT 2012
I think quite a few hosts have changed this policy. New Godaddy databases can be accessed remotely, and several other hosts I work with CrystalTech, and Arvixe allow remote access. I have connected to SQL Server databases from Access on both of the later hosting services. Arvixe allows as many SQL server databases as you want on their lowest level windows hosing. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, September 27, 2012 2:03 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Free Cloud based MySQL Does your web host allow you to access the SQL Server database remotely? Very few do - almost invariably, the only way to access a web database is through the web server, all other originating IP addresses are blocked (that's why you need phpMyAdmin or similar running on the web server to administer the database. The advantage of this one is that you don't need an intermediate web server based interface, you can access it directly from anywhere. -- Stuart On 27 Sep 2012 at 15:46, jwcolby wrote: > Stuart, > > My web hosting supplies a SQL Server database. I could just migrate the data to there I suppose. > > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > On 9/26/2012 9:12 PM, Stuart McLachlan wrote: > > <quote>A ridiculously simple, seriously powerful CLOUD DATABASE > > Xeround is an elastic, always-on database-as-a-service for your MySQL applications</quote> > > . > > http://xeround.com > > > > You can get a free account with up to 10MB of storage. > > > > I just signed up for their free account, created a simple table in MySQL with their > > phpMyAdmin interface, created a MySQL ODBC connection in an Access application and > > added/editted and deleted a few records. It worked fine. > > > > This may be of interest to JC for his prisoner release back-end instead of messing around > > with Hamachi and an Access BE. I'm not sure if he is on the Tech list, so I've sent this to the > > Access list as well :) > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com