Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me

7/16/2014 6:00:17 AM
Microsoft Access Expert 24
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
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.

Permanent Link
Course Link: Microsoft Access Expert 24
Keywords: access expert 24 rss feed news feed xml sql server
Page Tag: whatsnew
Post Reply

Microsoft Access Expert 24 Comment from Rhys T @ 3/3/2018
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.


Reply from Alex Hedley:

What happens when multiple users access the db?
Show Just This Thread        Post Reply
Microsoft Access Expert 24 Comment from Rhys T @ 3/1/2018
Hi

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?

Thanks


Reply from Alex Hedley:

Sharepoint isn't covered in this lesson.

It's briefly mentioned in a couple of lessons sharepoint but not what you're after.
Show Just This Thread        Post Reply
SQL Server database Comment from Dennis Owens @ 4/24/2016
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.


Reply from Alex Hedley:

If you want them to connect to your SQL Instance they will need a program to do that,
If you have built the db in Access you will have to share that and the connection details.
Show Just This Thread        Post Reply
Web Based Data Comment from Anthony Bardaro @ 11/22/2015
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!!!


Reply from Alex Hedley:

Glad you found it useful Anthony
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna R @ 10/2/2015
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.
The other thing I found out is that I had to download Microsoft SQL Server Management Studio to be able to make any changes to the tables already on the server.
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna Rosen @ 9/29/2015
Hi Alex,
Finally, it seems that I found the solution: set 0 as the default in table properties.
Thank you
Brauna


Reply from Alex Hedley:

Which value did you set to 0?
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna R @ 9/1/2015
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
WebHosting - Manage
Under Databases - SQL Server
Click on "Admin Tool"
Login
Click on Tables
Choose your Table
Under the last column - Actions you can add/edit your records.
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna R @ 8/31/2015
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."
I am using a DSN source created as per the tutorial.  I did notice however, on the same article, that the Access Database is referred to as an .mdb file whereas all my databases are .accdb.  Could that be a problem?


Reply from Alex Hedley:

Yeah it's an old article, so 2003 isn't supported but XP has just gone EOL so that's likely.
It mentions mdb as it's 2003 which is the file extension used there. 2007 onwards uses .accdb.

Can you edit the db in the online SQL Server admin GoDaddy provides?
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna R @ 8/31/2015
Thank you for your response.  Yes, the backend is on GoDaddy SQL server.  I was able to export the tables  but not able to edit records (Write conflict).  I tried the resolution suggested on one of the articles you sent but it still does not work.Perhaps it is because SQL stopped supporting Access with the 2003 version (I have 2010).
I am almost ready to give up..


Reply from Alex Hedley:

SQL Server still supports later versions of Access. Where did you read otherwise?
I have many dbs connected via Access to MSSQL without a problem,
Are you connecting with a DSN?
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna Rosen @ 8/26/2015
Hi Alex,
I have not yet resolved this.  I tried the Record Locks on Client Settings.  The database is stored locally, on my machine.  Godaddy could not help me with this issue.
You mentioned a "previously Linked article" but I did not see it.  Could you send me the link for that.
Thanks
Brauna


Reply from Alex Hedley:

The blue underlined words in a post are links. There is one that says "MS Article", just click on that.
Is the backend on a GoDaddy MS SQL Server? Is that why you asked them for help?
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna Rosen @ 8/5/2015
I am the only user at this time and I do have a few forms depending upon the table.
Thanks


Reply from Alex Hedley:

Did you try the RecordLocks or get a chance to read the previous linked article?
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna R @ 8/3/2015
Hi Alex,
Yes, I am the only user at this time.  The front end is stored on the desktop of my laptop..
Thanks,
Brauna


Reply from Alex Hedley:

Do you have multiple forms using the same record source?

MS Article
Set the RecordLocks property of the form to Edited Record.
Show Just This Thread        Post Reply
Write Conflict Comment from Brauna Rosen @ 7/30/2015
Hi,
I am getting a "Write Conflict" message when trying to edit a record that has been previously saved.  It is " This record has been changed by another user since you started editing it." It will not allow me to save the record at all.
Any idea what I am doing wrong?
Thanks


Reply from Alex Hedley:

Are you the only user using this db?
Is it stored locally on your machine or on a network drive?
Show Just This Thread        Post Reply
GoDaddy Options Comment from Brauna Rosen @ 6/17/2015
Please disregard my last message.  It worked!!!Thanks


Reply from Alex Hedley:

Glad you got it to work.
Show Just This Thread        Post Reply
GoDaddy Options Comment from Brauna Rosen @ 6/16/2015
Thanks for the response, however, I am still having difficulties. I called GoDaddy support and they say that they do not support Access on their server any longer.  Am I just having communication issues with them? I am about to give up unless you can help me further.


Reply from Alex Hedley:

Are you not uploading your Access Tables to your MS SQL Server Instance?
Show Just This Thread        Post Reply
GoDaddy Options Comment from Brauna Rosen @ 6/11/2015
Hi Richard,
your tutorials are so clear but when I went to configure on Go Daddy all their screens have changed and I cannot seem to be able to get to the part where I can find the host name....


Reply from Alex Hedley:

My Account
Web Hosting - Manage (button)
OPTIONS & SETTINGS
Databases
  SQL Server

Actions
  Details
Show Just This Thread        Post Reply
Excellent course Comment from CHARLES FULGHAM @ 2/7/2015
Excellent course Mr. Rost!  It would be beneficial for me to know how to utilize online database hosting strictly to BACKUP table records on a nightly basis.  I m sure you cover this somewhere already, but just thought I d throw it out there.  Thanks again!
Show Just This Thread        Post Reply
Thanks for this excellent lesson Comment from Selby Halfpenny @ 1/27/2015
Dear Richard, thanks for this excellent lesson, your the coolest
Selby
Show Just This Thread        Post Reply
MySQL Database Driver Comment from Brian Farley @ 11/13/2014
For those stuck with a MySQL database figured I'd post what I needed to do...

You will need to download the driver here: http://dev.mysql.com/downloads/connector/odbc/5.1.11html
Then pick that out of the driver pick list, it should be near the bottom labeled "MySQL ODBC 5.1 Driver"  you should be able to follow the rest.

The Microsoft ODBC for Oracle (maker of MySQL) doesn't work.

Keep up the great work Rick!!


Reply from Alex Hedley:

Thanks Brian
Show Just This Thread        Post Reply
different username and password Comment from Robert R @ 9/29/2014
Hi Richard,
I need to share my database with multiple users but they all need a different username and password to access records that I hae assigned to them....will you be having a class on this or does one exist?
Thanks


Reply from Rick Rost:

Hi Robert. This is covered in the SECURITY SEMINAR.
Show Just This Thread        Post Reply
More SQL Server Comment from Michael Adams @ 8/21/2014
Hi Richard,

Echoing another comment (the squeaky wheel gets the grease as you say), I would love to see more on SQL server, securing it and optimising it etc (i am guessing that by optimising it you mean choosing which queries/views on the server side and which to have on the application side. Is that right? Just learning all this lingo).

Thanks, Mike


Reply from Richard Rost:

You're not alone. Lots of people have been asking for more SQL Server classes, and your request SHALL be honored... as soon as I finish the Windows 8 and Office 2013 classes that I'm WAY behind on.
Show Just This Thread        Post Reply
SQL on a LAN Comment from Samuel M @ 8/18/2014
Great I am staying tuned waiting for this solution
Show Just This Thread        Post Reply
SQL on a LAN Comment from Samuel M @ 8/17/2014
Great. but what about SQL Sever in a branch office or  in a single local network (LAN). can anyone use the same technique. I have tryed in vain can you help ?


Reply from Richard Rost:

Yes, but the SQL Server has to be set up with Web access. This may involve changing firewall settings and port forwarding and it a lot more complex than I can go into here. I'll be putting together a full seminar on SQL Server that will discuss setting it up in YOUR office and not using a hosted solution.
Show Just This Thread        Post Reply
Sharepoint SQL Azure Comment from Warren G @ 8/17/2014
Out of interest- If you have a access web app hosted on SharePoint online- can you still connect to 3rd party web services such as the weather as you showed in the coarse?


Reply from Richard Rost:

I have not tried that from an Access Web App; only a desktop Access application. Not sure if it's possible or not.
Show Just This Thread        Post Reply
Sharepoint SQL Azure Comment from Warren G @ 8/16/2014
Hi Richard- The connection to the SQL database online course was excellent. However would it be possible to do a course on connecting to SharePoint online- IE Sql Azure. It would be great to share that database to external users using sharepoint online. Thanks


Reply from Richard Rost:

Yep. That's not too much more difficult. I have an Office 365 Business account with Sharepoint and I'll be talking about how to use that soon.
Show Just This Thread        Post Reply
Microsoft Access Expert 24 Comment from Samuel M @ 8/14/2014
Owesome  ! Very good video. But Tell me what time you expect SharePoint to be available


Reply from Richard Rost:

I really can't say, Samuel. I'm behind schedule on several other lessons that need to get finished first. Hopefully this fall.
Show Just This Thread        Post Reply
Default values on SQL server Comment from Richard Lanoue @ 8/9/2014
In a previous lesson I learned about creating a log:

Private Sub LogIt(Description As String, Notes As String)

    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO LogT (Description, Notes) " & _
        "Select '" & Description & "', '" & Notes & "'"
    DoCmd.SetWarnings True

End Sub

and it worked like a charm... until I uploaded it to a server where the default values of the date/time didn't transfer with the tables... therefore, I can't seem to time stamp the event in the log.  

is there a code like an update query in sql to place just before the sequence of the log?  or is there a better way?

Rick


Reply from Richard Rost:

You should be able to set up a default value on the server field, but you'll have to do that in your server's table config. It's different for each server, unfortunately.

The alternative is to just send the date/time value with the other two fields and make your function handle it.
Show Just This Thread        Post Reply
thank you Rick I need to see more of SQL server a Comment from MUBEEZI MICAH @ 8/8/2014
thank you Rick. I need to see more of SQL server and or sharepoint as well.


Reply from Richard Rost:

More SQL Server will be coming up this fall, for sure.
Show Just This Thread        Post Reply
Is there a RSS Feed site you recommend with things Comment from Richard Lanoue @ 8/3/2014
Is there a RSS Feed site you recommend with things like.. The current interest rate by the Fed Reserve, stock quotes, ballgame scores????
Rick


Reply from Richard Rost:

I have not spent the time to look for ANY of those things. Try Googling them.
Show Just This Thread        Post Reply
I got a Godaddy account but it looks like I got a Comment from Richard Lanoue @ 8/2/2014
I got a Godaddy account but it looks like I got a wrong package... I got something called Cpanel and there is different icons when I click Launch and No SQL SERVER Icon
Rick


Reply from Richard Rost:

Yep - we talked about this in email. You ordered a LINUX server. You need a WINDOWS server. Linux has MySQL which SHOULD work, but it's not the same as the SQL Server which comes with Windows hosting.
Show Just This Thread        Post Reply
Master copy Comment from James G @ 7/28/2014
Maybe I could just create a database with only one form in it that would update the ManningT without distributing the whole master front end. I could then just access the ManningT from the master copy and charge forward.  Would that work?


Reply from Richard Rost:

That should work just fine.
Show Just This Thread        Post Reply
Comment from Wayne Ayotte @ 7/26/2014
Thanks for this lesson Rick, I would like to see more about this lesson but mostly I would to see a lesson about SharePoint
Show Just This Thread        Post Reply
I would love to see a whole seminar on event timer Comment from Kenneth Breig @ 7/24/2014
I would love to see a whole seminar on event timers


Reply from Richard Rost:

I'll be covering them in more detail soon.
Show Just This Thread        Post Reply
Thanks for another good lesson Comment from Larisa Kiseleva @ 7/24/2014
Thanks for another good lesson- I just can't wait when you release seminar about sql server and SharePoint. Do you have any idea when you can start work on this seminar?  Thanks


Reply from Richard Rost:

Sorry, I really can't put a date on it right now. I've got so much other stuff I have to finish first.
Show Just This Thread        Post Reply
Export multiple tables Comment from Jim Gray @ 7/24/2014
Rick,
Do you have to upload tables singly or can you do them all at once?


Reply from Richard Rost:

You have to export them one at a time to ODBC sources.
Show Just This Thread        Post Reply
Master copy Comment from James Gray @ 7/23/2014
Rick,
This would be a great way to have all the members of our volunteer EMS staff sign up for their standby time right?  I could just upload the ManningT to the web, have them use the database through a form designed specifically for sign ups and it would then be just like me doing it from the "master" copy.  Am I thinking straigt?


Reply from Richard Rost:

Yep. Just remember... whoever has access to that front-end database has the password for your tables. It's contained in the Access database and a hacker can get it out if determined.
Show Just This Thread        Post Reply
Access and SQL server databases Comment from Robert Miller @ 7/22/2014
Richard, I have been waiting for a LONG time for this lesson on SQL server databases!  Thank you so much!  

I have a question: Is it possible to set all this up and then share a version of the Access database with someone that does not have Access on their machine?  I know a few people that have MS Office but not the version with Access so I cannot share the front-end database with them.

Thanks again for all of this information and for everything you do!

Rob



Reply from Richard Rost:

You SHOULD be able to create an Access database, connect it to your SQL Server backend, and then package and deploy that database using the Access Runtime Edition which means they wouldn't need a purchased copy of Access - HOWEVER I haven't tried this myself, so this is just a theory. Let me know if it works.
Show Just This Thread        Post Reply
Comment from Patrick Russell @ 7/16/2014
Thanks Richard for the Online SQL Server segment.  I would love to see more both with SQL Server and SharePoint.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
 
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 3+5:
  
  Notify me when the News is updated.
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

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

3/23/2018Microsoft Access Developer 7
2/22/2018Microsoft Access Developer 6
2/22/2018Access Assistance Available
2/21/2018Putting Access Databases Online
2/18/2018Microsoft Access Developer 5
2/10/2018Microsoft Access Developer 4
2/1/2018Access Tip: Salary History
7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP