Go Back   Access World Forums > Apps and Windows > Web Design and Development

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-02-2016, 10:43 AM   #1
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,364
Thanks: 543
Thanked 36 Times in 35 Posts
Dick7Access is on a distinguished road
What to look for db hosting

Free hosting
Disk space: 1GB
Monthly Traffic: 10GB
Domains Hosted: 3
MySQL(v.5.1)/ 10MB

does monthly traffic 10gb mean in the above ad mean download amount of bytes or does it mean even just browsing, or other. What should I look for if I was to have a 14000 record db hosted that will only be visited by a very limited amount of people?

Dick7Access is offline   Reply With Quote
Old 04-02-2016, 11:23 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,205
Thanks: 39
Thanked 3,299 Times in 3,195 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: What to look for db hosting

it typically means upload and download whether it be data or web pages - the max allowed size of your db is 10mb which is not very big - access allows 2gb so only 5%. But you would be able to upload/download your entire db 100 times before hitting the monthly limit. Whether 14000 records will fit in 10mb depends on the size of the records and the level of indexing - assuming your existing access (tables only) back end is less than 10mb you should be OK. The rest of the disk space will be for your website pages etc.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
Dick7Access (04-02-2016)
Old 04-02-2016, 11:30 AM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,372
Thanks: 350
Thanked 761 Times in 726 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: What to look for db hosting

You mention MySQL hosting, I don't know if I've got this right, but I understand that some hosting companies have stopped letting people have access to MySQL directly, they only let you have access to it if you are using, like, WordPress.

I said I'm not sure if I've got that right but I'm sure I read that somewhere recently! If it is true it's worth making sure you can get the access rights you need before you sign up.

By the way I use 4D Hosting. http://www.4dhosting.com/ I have always found them helpful. BTW - it might be on their website where I read about the MySQL issue!

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Dick7Access (04-02-2016)
Old 04-02-2016, 11:52 AM   #4
Dick7Access
Dick S
 
Dick7Access's Avatar
 
Join Date: Jun 2009
Location: Belleview, FL
Posts: 3,364
Thanks: 543
Thanked 36 Times in 35 Posts
Dick7Access is on a distinguished road
Re: What to look for db hosting

Quote:
Originally Posted by CJ_London View Post
it typically means upload and download whether it be data or web pages - the max allowed size of your db is 10mb which is not very big - access allows 2gb so only 5%. But you would be able to upload/download your entire db 100 times before hitting the monthly limit. Whether 14000 records will fit in 10mb depends on the size of the records and the level of indexing - assuming your existing access (tables only) back end is less than 10mb you should be OK. The rest of the disk space will be for your website pages etc.
CJ thanks for answering. Lets see if I understand you correctly. If all I have are my tables / back end on a server, then there would not be any web pages, Is that correct? If I open up my db and enter a new record that is upload, is that correct? How to I determine what size my tables are? I right click on table properties but it just gives me modified date.
Dick7Access is offline   Reply With Quote
Old 04-02-2016, 02:21 PM   #5
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,205
Thanks: 39
Thanked 3,299 Times in 3,195 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: What to look for db hosting

Quote:
If all I have are my tables / back end on a server, then there would not be any web pages
You are missing Unc's point - you will not be able to connect to the db except via web pages. You would not use access at all
Quote:
How to I determine what size my tables are?
as I suggested - you have an access back end with 14000 records? so compact it and see how big it is in windows explorer. If you haven't populated it yet, then to calculate an approximate size, add together the datatype sizes (e.g. Boolean 1 byte, number 2-16 bytes depending on type) for a record. double up for those fields which are indexed and multiply by 14000. There may be a better way but it will give you an idea.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
Dick7Access (04-02-2016)
Old 05-13-2016, 09:40 AM   #6
pkraja
Newly Registered User
 
Join Date: Nov 2015
Location: San Francisco, CA
Posts: 6
Thanks: 2
Thanked 0 Times in 0 Posts
pkraja is on a distinguished road
Re: What to look for db hosting

I am using Access as front end to a mySQL hosted by a third party company. My internal users can view, edit, add and delete records. My external users use a web interface to view, edit, delete, and add records. To say that Access cannot connect to mySQL hosted on the web is simply not true.

pkraja is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Web hosting Oldsoftboss Web Design and Development 11 11-22-2014 04:10 PM
Web Hosting GendoPose Access Web 2 02-13-2014 08:54 AM
VPS hosting Lightwave The Watercooler 5 06-09-2012 11:57 AM
Hosting Parariddle Web Design and Development 1 02-11-2009 01:58 AM
My new hosting Neogame General 0 10-07-2002 07:57 AM




All times are GMT -8. The time now is 06:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World