Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Expert 19    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
What is Dataverse
Alan Stevens 
    
4 months ago
My current version of Access (Microsoft Access – Version 16.) via Office 365 has an additional button called Dataverse on the External Tab on the ribbon. I will attach a screen clip to show what it looks like. Richard doesn't include this export option in these videos (being made 11 years ago). Does he cover what this does anywhere else?
Alex Hedley  @Reply  
           
4 months ago
Alex Hedley  @Reply  
           
4 months ago
Not yet, but maybe in the future, depending on how many people are interested.
Alan Stevens OP  @Reply  
    
4 months ago

Thomas Gonder  @Reply  
      
4 months ago
You mean this explanation from Microsoft doesn't clearly explain what dataverse is?

"Add grounded enterprise data and make your copilots actionable with Microsoft Dataverse, the enterprise data platform for Copilot."

I worked in advertising for 30 years. You would think I would love inane gibberish as much as the next guy. Is that grounded data like grounded airplanes? Remember the old joke about "What if Microsoft made airplanes (with the same reliability as Windows)"?
Richard Rost  @Reply  
          
4 months ago
I talked a little bit about Dataverse way back in QQ55. At the time I was considering putting together some lessons for beginner Access developers who want an easy way to get their data online - and I still may. However for serious Access developers (which make up the vast majority of my students), Dataverse is just a bump in the road on the way to SQL Server.

I've actually been putting this together for an upcoming video, or even just another QQ mention:

Microsoft Dataverse is a managed, cloud-based data platform designed primarily for the Power Platform, not a full-featured relational database engine. It works well when you are building Power Apps solutions, need built-in security, authentication, and auditing, and want tight integration with Power Automate, Teams, and Microsoft 365. In those scenarios, Dataverse removes a lot of friction and lets non-developers build apps quickly without worrying about server management. That convenience is its strength, but also its limitation.

For most serious Access developers, Dataverse starts to feel restrictive pretty quickly. It does not offer true T-SQL, advanced query optimization, stored procedures, or the same level of control over indexing, performance tuning, and schema management that experienced developers expect. You also have to accept licensing costs, storage limits, and platform constraints that you do not control. If you enjoy designing normalized databases, writing complex queries, and scaling applications deliberately, Dataverse is going to feel like it gets in the way more than it helps.

That is why SQL Server remains the natural next step for Access developers. The migration path is clean, the concepts transfer directly, and Access continues to work extremely well as a front end. You gain scalability, performance, and professional-grade database features without losing the development model you already understand. Dataverse is not a bad tool, but it is a platform convenience layer, not a destination for people who want to get serious about databases.

The smart move is knowing both and using each where it makes sense. SQL Server should be your foundation, and Dataverse is something you reach for only when Power Platform requirements demand it. In Star Trek terms, Dataverse is the holodeck. SQL Server is engineering.
Thomas Gonder  @Reply  
      
4 months ago
Still looking for that SQL Server seminar that takes us from converting an only Access application to something that runs with SQL Server as the backend, as well as setting up SQL Server locally for developers and how to administer it.
Alex Hedley  @Reply  
           
4 months ago
Alex Hedley  @Reply  
           
4 months ago
Captain's Log: Dataverse
Thomas Gonder  @Reply  
      
4 months ago
One that expresses how I feel when viewing modern ads:

https://www.facebook.com/share/r/1Do63crBwQ/?mibextid=wwXIfr
Richard Rost  @Reply  
          
4 months ago
Those dumb corporate buzzwords have been around forever. Just ask Dilbert. LOL
Thomas Gonder  @Reply  
      
4 months ago
Richard I've been around for almost forever, and it's gotten way worse. I can't understand anything they say other than "and" and "the".

On a side note, being under a rock (down under "America"), I recently read what happened to Scott Adams, and it is so sad how PC stifled his brilliant mind. Also the cancer diagnosis. Lesson: Just repeating what you read in the news can get you canceled.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 19.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/30/2026 3:05:31 AM. PLT: 1s