Steve, thanks for bringing in Judd to demo this for us. Just a couple of clicks to migrate legacy Access databases is a great feature. I work with an organization that will be able to make use of this as they migrate their data to the Power Platform.
Thank you so much for this video. Question, once I add data in the app it doesn't go directly into MS Access, I need to close access and reopen it to see the new information. Is there a way around this?
So with this linking process; does it matter where the access database is stored after migration? If it is stored on a local computer and that computer is shut down what happens?
@@SteveWinward Hi. So are we able to append (from Access) to the dataverse table? 2gig limit was always a problem, so if I understand correctly, the dataverse overcomes this issue. ie You can keep running your old macros/VBA in Access to clean data but now append to the final LARGE Dataverse table that has much higher limits than 2gig.
@@jamiegrayson3739 Based on my experience, Dataverse trashes everything you have done in access. I tested it with several automated macros that do inserts and updates and it will work for a while and then it will stop working. AzureSql is a better option for ms access developers or a CentOs server with Postgresql
Take a look at our docs below on this. It looks like you need to first join the Access beta program to be able to do this. docs.microsoft.com/en-us/powerapps/maker/data-platform/migrate-access-to-dataverse
Great question. Sorry for the delayed response. Dataverse will give you a lot more features and capabilities both on the security options and rapidly building applications with Power Apps. Hope this helps.
It is important to note that Dataverse is not compatible with MS Access. This is due to the fact that the primary keys utilized by Dataverse are not compatible with MS Access. Additionally, it is not any faster than Sharepoint, and it is impossible to use ANSI 92 SQL on your Sharepoint lists.
what abou the reports ? Once I have the data synchronized with the Dataverse and from PowerApps I can make an aplication, is it possible to "migrate" the Access reposts? In my case I have about 180 reports in access. How could you migrate the reports?
Hi Steve, the info in this video is great. I do not get the Dataverse option when I right-click on the table I want to export to dataverse. How do I enable that option?
Exactly, I keep on hearing how easy it is, but there is no link for Dataverse in MS Access to export. It appears you need to setup several items before this "Easy" click export to dataverse.
@@thomasjones9394 I just setup a free Azure DB/SQL and exported one major 1.7GB MS Access table to it and then removed it from access. I then created a link to the azure table within Access and it works nicely :) .. Now my database is only 688KB :). The only thing I need to do some research on is to fix the slow export of the original 1.7GB table to Azure, which was over 24 hours :x .
If users have substantial data on their current Access platform they will perhaps suffer some sticker shock at the monthly cost of Dataverse storage. Let's hope they do some capacity planning before jumping into this data migration.
Every customers use case will be different here. It’s a good point to be aware of costs for Dataverse storage as part of planning. I do think for most customers there are significant benefits to storing their data in the cloud versus hosting their database locally.
@@SteveWinward currently in the process of transitioning various analytics and metrics from legacy NMCI (Navy) and intranet to Power Apps Dataverse, SharePoint Online, and One Drive for business.
Steve, thanks for bringing in Judd to demo this for us. Just a couple of clicks to migrate legacy Access databases is a great feature. I work with an organization that will be able to make use of this as they migrate their data to the Power Platform.
Glad you enjoyed it!
@@SteveWinward pls let us known what version of ms access have dataverse. Pls tell us
@@akokohjoel9854 365 Version
Where can I find my Environment URL?
Thanks very much, this is exactly I need in this moment...
Glad it was helpful!
شكرا لكم على مشاركة الأفكار الجديدة
Thank you for the video, Steve! This is really helpful.
You're very welcome!
What version of ms access support dataverse?
Does this work on split databases so when you make and distribute a front end there are basically no tables on the client machines
Thank you so much for this video. Question, once I add data in the app it doesn't go directly into MS Access, I need to close access and reopen it to see the new information. Is there a way around this?
This question may have already been asked, but how do I use multiple tables in one application?
So with this linking process; does it matter where the access database is stored after migration? If it is stored on a local computer and that computer is shut down what happens?
How the relation between the table and grandparent tables are imported (query farther than 1 table away)? Since this is a limitation of Dataverse.
But what if I quit the company and this dataverse is tied to my Microsoft account? How do I create a power app account tied to the company and not me?
This is great! But, can I create only mobile apps? Or, can I use as a mini system on manage my work for example?
The 2gig limit for access does it applied to dataverse?
Dataverse has much higher limits than access databases.
@@SteveWinward Hi. So are we able to append (from Access) to the dataverse table? 2gig limit was always a problem, so if I understand correctly, the dataverse overcomes this issue. ie You can keep running your old macros/VBA in Access to clean data but now append to the final LARGE Dataverse table that has much higher limits than 2gig.
@@jamiegrayson3739 Based on my experience, Dataverse trashes everything you have done in access. I tested it with several automated macros that do inserts and updates and it will work for a while and then it will stop working. AzureSql is a better option for ms access developers or a CentOs server with Postgresql
Dataverse is not being displayed as an export data option in my access data base. what to do?
Take a look at our docs below on this. It looks like you need to first join the Access beta program to be able to do this.
docs.microsoft.com/en-us/powerapps/maker/data-platform/migrate-access-to-dataverse
Hi Steve (and Judd!). Excellent video! But is there any advantage to migrate Access data to Dataverse instead of Sharepoint?
Great question. Sorry for the delayed response. Dataverse will give you a lot more features and capabilities both on the security options and rapidly building applications with Power Apps. Hope this helps.
It is important to note that Dataverse is not compatible with MS Access. This is due to the fact that the primary keys utilized by Dataverse are not compatible with MS Access. Additionally, it is not any faster than Sharepoint, and it is impossible to use ANSI 92 SQL on your Sharepoint lists.
Dataverse functions more like a Database where SharePoint is more of a file storage.
Dataverse, where I it in ms access ? I don't have that export options. What's going on?
Same with me
what abou the reports ? Once I have the data synchronized with the Dataverse and from PowerApps I can make an aplication, is it possible to "migrate" the Access reposts? In my case I have about 180 reports in access. How could you migrate the reports?
Hi Steve, the info in this video is great. I do not get the Dataverse option when I right-click on the table I want to export to dataverse. How do I enable that option?
Exactly, I keep on hearing how easy it is, but there is no link for Dataverse in MS Access to export. It appears you need to setup several items before this "Easy" click export to dataverse.
@@SlayerSlashHobbies Ditto
@@thomasjones9394 I just setup a free Azure DB/SQL and exported one major 1.7GB MS Access table to it and then removed it from access. I then created a link to the azure table within Access and it works nicely :) .. Now my database is only 688KB :). The only thing I need to do some research on is to fix the slow export of the original 1.7GB table to Azure, which was over 24 hours :x .
@@SlayerSlashHobbies LOL. Sounds fantastic. How can we talk?
@@SlayerSlashHobbies I am interested, how did you do, I am finding it difficult.
Thank you for sharing that,
My pleasure!
If users have substantial data on their current Access platform they will perhaps suffer some sticker shock at the monthly cost of Dataverse storage. Let's hope they do some capacity planning before jumping into this data migration.
Every customers use case will be different here. It’s a good point to be aware of costs for Dataverse storage as part of planning. I do think for most customers there are significant benefits to storing their data in the cloud versus hosting their database locally.
@@SteveWinward currently in the process of transitioning various analytics and metrics from legacy NMCI (Navy) and intranet to Power Apps Dataverse, SharePoint Online, and One Drive for business.
Can I use multiple SharePoint lists (one for each Access table) instead of Dataverse?
You can use SharePoint lists and SharePoint folders as connectors if you want.
I needed this