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.
@SteveWinward
2 жыл бұрын
Glad you enjoyed it!
@akokohjoel9854
2 жыл бұрын
@@SteveWinward pls let us known what version of ms access have dataverse. Pls tell us
@Freeflier1978
9 ай бұрын
@@akokohjoel9854 365 Version
@wellsuz2
6 ай бұрын
This is great! But, can I create only mobile apps? Or, can I use as a mini system on manage my work for example?
@fvelez78
2 жыл бұрын
Thanks very much, this is exactly I need in this moment...
@SteveWinward
2 жыл бұрын
Glad it was helpful!
@garycurtis
Жыл бұрын
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?
@CorpoMax
2 жыл бұрын
Hi Steve (and Judd!). Excellent video! But is there any advantage to migrate Access data to Dataverse instead of Sharepoint?
@SteveWinward
Жыл бұрын
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.
@anzus101
Жыл бұрын
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.
@Freeflier1978
9 ай бұрын
Dataverse functions more like a Database where SharePoint is more of a file storage.
@user-tb3gs1mw4g
Жыл бұрын
شكرا لكم على مشاركة الأفكار الجديدة
@dwaynemcdonald9554
7 ай бұрын
This question may have already been asked, but how do I use multiple tables in one application?
@vincentpaquet6357
Жыл бұрын
How the relation between the table and grandparent tables are imported (query farther than 1 table away)? Since this is a limitation of Dataverse.
@trooperstravels
7 ай бұрын
Does this work on split databases so when you make and distribute a front end there are basically no tables on the client machines
@vitorhenriques2450
Жыл бұрын
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?
@jonsteen
Жыл бұрын
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?
@AlexClements
2 жыл бұрын
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?
@slayer_slash7369
2 жыл бұрын
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
2 жыл бұрын
@@slayer_slash7369 Ditto
@slayer_slash7369
2 жыл бұрын
@@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 .
@thomasjones9394
2 жыл бұрын
@@slayer_slash7369 LOL. Sounds fantastic. How can we talk?
@akokohjoel9854
2 жыл бұрын
@@slayer_slash7369 I am interested, how did you do, I am finding it difficult.
@hayleeadamson6449
2 жыл бұрын
Thank you for the video, Steve! This is really helpful.
@SteveWinward
2 жыл бұрын
You're very welcome!
@shaiby786
2 жыл бұрын
Dataverse is not being displayed as an export data option in my access data base. what to do?
@SteveWinward
2 жыл бұрын
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
@marvinbrando722
2 жыл бұрын
Dataverse, where I it in ms access ? I don't have that export options. What's going on?
@akokohjoel9854
2 жыл бұрын
Same with me
@rajeshmajumdar4999
2 жыл бұрын
Thank you for sharing that,
@SteveWinward
2 жыл бұрын
My pleasure!
@Indygoflow1
Жыл бұрын
I needed this
@JeffersonMartinSynfluent
2 жыл бұрын
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.
@SteveWinward
2 жыл бұрын
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.
@Freeflier1978
9 ай бұрын
@@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.
@SmartLearningAI
11 ай бұрын
Where can I find my Environment URL?
@akokohjoel9854
2 жыл бұрын
The 2gig limit for access does it applied to dataverse?
@SteveWinward
2 жыл бұрын
Dataverse has much higher limits than access databases.
@jamiegrayson3739
2 жыл бұрын
@@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.
@anzus101
Жыл бұрын
@@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
@akokohjoel9854
2 жыл бұрын
What version of ms access support dataverse?
@damiangawlowski1297
2 жыл бұрын
Can I use multiple SharePoint lists (one for each Access table) instead of Dataverse?
@Freeflier1978
9 ай бұрын
You can use SharePoint lists and SharePoint folders as connectors if you want.
Пікірлер: 48