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  
Microsoft Access Expert 24
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

Microsoft Access Expert Level 24 is 1 hour, 33 minutes long. In this class we will learn how to import real-time data from web sites using their RSS feeds. We will display current news and weather conditions. Then, we will learn how to share our Access data with others over the Internet by setting up an inexpensive and easy-to-use online SQL Server database that will host our tables. Topics include:

- Import RSS Feed Data
- Download Latest News from Web Sites
- Display Current Weather Conditions
- Use the WebBrowser Control
- Display Images from a Web Page
- Program Timer Events
- Launch a Macro at Timed Intervals
- Setup Online SQL Server Database
- Create ODBC Connections & DSN Files
- Share Access Data via the Internet

Click here for more information on Access Expert Level 24, including a course outline, sample videos, and more. This course was recorded using Access 2013. This class follows Expert Level 23. The next class in the series is Access Expert 25.

Weather feed for Expert 24 Upload Images   Link 
Robert Taplin 
4 days ago
Hi Richard,
Weather Underground no longer offers a no-fee option. I have searched and haven't found an alternative. Any feedback from recent Expert 24 students on another option?
Thank you, Bob
Richard Rost
3 days ago
As I'm sure I mentioned in the video, these services come and go. The class is 7 years old, so I'm not surprised they've changed their model. Anyhow, a Google search for "free weather api" turns up a whole bunch of them that are still free. The coding will be very similar.
Add a Reply
Microsoft Access Expert 24 Upload Images   Link 
Rhys T 
3 years ago
When it's on a shared drive, it creates dublicate back ends... Just copies the folder if more than one person is entering data.

Reply from Alex Hedley:

So you have the BE on the Shared Drive and the FE on each user's PC. Read More...
Add a Reply
Microsoft Access Expert 24 Upload Images   Link 
Rhys T 
3 years ago
Thanks for the reply. Will this cover multiple users (up to 10) inputing/editing data on the back end at the same time.

That's the problem I've had see. I've build a database that works well using these classes, but can't get multiple users to work off one back end. Read More...
Add a Reply
Microsoft Access Expert 24 Upload Images   Link 
Rhys T 
3 years ago

Does this class help with using sharepoint as a server?

Does this also work with multiple users inputting/editing data at the same time? Or does it only allow 1 user at a time to do that? Read More...
Add a Reply
SQL Server database Upload Images   Link 
Dennis Owens 
5 years ago
After setting up the SQL Server database does the other person using this needs Access loaded on their computer? I am using Access 2016, using an earlier addition should also work, right.

I too would like to see more on this subject of SQL Server database. Read More...
Add a Reply
Web Based Data Upload Images   Link 
Anthony Bardaro 
6 years ago
I have been chasing down how to access web based data with a desktop front end for awhile. The Online SQL Server database lesson is great!!! I already had a GoDaddy windows hosting account and got it running very quickly. I did add a primary key index that was not automated. Other than that, it works flawlessly. Thanks!!! Read More...
Add a Reply
Write Conflict Upload Images   Link 
Brauna R 
6 years ago
All fields in the table (except for the Primary key, autonumber of course).  Also, all forms have record locking set to Edited Records.  I will continue to test, next with a live database. Read More...
Add a Reply
Write Conflict Upload Images   Link 
Brauna Rosen 
6 years ago
Hi Alex,
Finally, it seems that I found the solution: set 0 as the default in table properties.
Thank you

Reply from Alex Hedley:

Which value did you set to 0?
Add a Reply
Write Conflict Upload Images   Link 
Brauna R 
6 years ago
I have not been able to edit in "MyLittleAdmin" I can see the tables but have not found a way to edit.

Reply from Alex Hedley:

GoDaddy provide their own.
Login to your account
Add a Reply
Write Conflict Upload Images   Link 
Brauna R 
6 years ago
That is encouraging.  I did read that on the article you linked "Support for Office 2003 has ended
Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected." Read More...
Add a Reply

Show Older Comments...
View in Table Format

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.

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

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

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

YouTube Channel    LinkedIn
Keywords: access expert 24 rss feed news feed xml sql server  Page Tag: whatsnew  PermaLink