Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Putting Access Databases Online
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   3 years ago

Now that Microsoft has dropped support for Access Web Databases, I've been getting LOTS of emails from people asking what the best way to share their Access data online is.

If you want to share data online using the Access database that you've built, the BEST way to do it is to upload the TABLES to an online SQL Server. You can get incredibly cheap hosting for this from most major ISPs (including the one we use, GoDaddy), and it's a relatively easy and secure way to share your data. You just have to upload the tables, link them to your Access front-end, and distribute that front-end file to whomever needs to use it. Plus, you can still develop additional solutions in another language like ASP to connect directly to the data from a web page, for example. I cover how to upload your Access tables to an online SQL Server database in Access Expert Level 24, Lesson 4.

Now, this isn't the best solution if you have a HUGE database. If you're talking about hundreds-of-thousands of records, then you might find this solution too slow. But, if you have a reasonably sized database, then this is a simple, inexpensive solution that may work well for most small and mid-sized businesses.

Putting Access Databases Online Upload Images   Link 
Adonis B 
3 years ago
Richard, on AccessExpert24 you teach how to link the tables, but how to optimise the FrontEnd( forms-reports etc) once is linked to an online server? as the application is far slower and forms with sub-forms, dont work properly when there is a moderate amount of data Read More...
Add a Reply
Putting Access Databases Online Upload Images   Link 
Dennis O 
3 years ago
Will OneDrive work? I'm not familiar how to use it.


Reply from Alex Hedley:

Not a great solution due to sync conflicts but I'm sure people here have said they've used it without problems. Read More...
Add a Reply
Putting Access Databases Online Upload Images   Link 
Adonis B 
3 years ago
what about if I have a huge database, what will be the best solution and where you teach how to do it


Reply from Alex Hedley:

Upload to an MS SQL Server Instance.
Add a Reply
Putting Access Databases Online Upload Images   Link 
Shallena A 
3 years ago
What does that mean?  Is that somewhere online? Are you saying to set up a server at home?  I don't understand your answer.


Reply from Alex Hedley:

Have you see Access Expert Level 24? Read More...
Add a Reply
Putting Access Databases Online Upload Images   Link 
Steve V 
3 years ago
Tried going to GoDaddy and what a mess! No one there seems to understand what I'm looking for. They keep trying to sell me an expensive product.  $949 for 36 months but will give me a starting deal for $579 for 36 months. Won't go shorter than 36 months. Read More...
Add a Reply
Putting Access Databases Online Upload Images   Link 
Shallena A 
3 years ago
I just got off of chat with Cheyenne at GoDaddy and she says that they no longer host MS Access Databases.  I told her that the information on their website said that Windows Classic Hosting Accounts allow for Access hosting and she said that is on their old platform and the new one does not. Any other suggestions for a cheap way to be able to have 2 people be able to use the database from different locations? I want to use it at my house and my son use it on his laptop where ever he is at. Thanks in advance Read More...
Add a Reply
Putting Access Databases Online Upload Images   Link 
simon b 
3 years ago
The mysql web site has details about migrating access to mysql follow the link
https://www.mysql.com/why-mysql/white-papers/a-guide-for-migrating-from-microsoft-access-to-mysql/
Add a Reply
Putting Access Databases Online Upload Images   Link 
Martin G 
3 years ago
How can i do with MySql. It does not work


Reply from Alex Hedley:

What doesn't work? What have you tried?
Add a Reply

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: online sql server access  PermaLink