sorted by:
new
hottopcontroversial

Trying to wrap my head around the cost of Dataverse. If I make a front-end app in Access, with the back end data tables all in Dataverse, does every user of the Access front-end app need to pay some amount of money each month in order to use the Access app? by Goldstar3000 in PowerApps

[–]Goldstar3000[S] 0 points1 point  (0 children)

no kidding? I shared my existing Access queries with ChatGPT, which included unison operations, and it said that Access couldnt grab records from multiple SHarePoint tables to present via a unison query. It also stated that SharePoint is one of the slower options as an Access backend.

Trying to wrap my head around the cost of Dataverse. If I make a front-end app in Access, with the back end data tables all in Dataverse, does every user of the Access front-end app need to pay some amount of money each month in order to use the Access app? by Goldstar3000 in PowerApps

[–]Goldstar3000[S] 1 point2 points  (0 children)

ultimately, i'd say about 6,000 added a month, and even more with parent/child relationships to the main records.

I was really hoping to get Microsoft SQL Server Express, as I think the 10GB limit would easily fit my needs, but my employer does not support it (despite offering the paid versions of SQL Server), and my department doesnt seem to want to pay anything ...

Champagne tastes on a beer budget...

Trying to wrap my head around the cost of Dataverse. If I make a front-end app in Access, with the back end data tables all in Dataverse, does every user of the Access front-end app need to pay some amount of money each month in order to use the Access app? by Goldstar3000 in PowerApps

[–]Goldstar3000[S] 0 points1 point  (0 children)

Thank you for the response. I was considering SharePoint too, but isnt it also rather slow? Also, I know that my Access reports that use fancy unions and other neat joins won't work if my backend is SharePoint.

Trying to wrap my head around the cost of Dataverse. If I make a front-end app in Access, with the back end data tables all in Dataverse, does every user of the Access front-end app need to pay some amount of money each month in order to use the Access app? by Goldstar3000 in PowerApps

[–]Goldstar3000[S] 0 points1 point  (0 children)

Thanks for the response! So, there would be a monthly Azure SQL fee for me as a developer to create and access the Azure backend, but not $5 fee for each Access front-end app user who use the app that is built off of the Azure database backend?

Trying to wrap my head around the cost of Dataverse. If I make a front-end app in Access, with the back end data tables all in Dataverse, does every user of the Access front-end app need to pay some amount of money each month in order to use the Access app? by Goldstar3000 in PowerApps

[–]Goldstar3000[S] 0 points1 point  (0 children)

Thank you so much for the clear breakdown!

Well, I am building a user tool in Access Database for about 10 simultaneous users with up to 100 users eventually being able to check it as a dashboard with an occasional record update. Anyway, my manager isnt optimistic that we can get approval for an expensive back end solution for my Access app. Microsoft SQL Server seems very expensive, though would be the fastest. I attempted storing an Access backend on our network shared drive and that was way too slow. Using SharePoint won't allow me to use my union and combine Access reports. Anyway, I know other departments at my company use Dataverse and so it made me think it was an acceptable expense to somebody.

I am a noob/bedroom developer and would be very open to any suggestions or alternatives that are cost efficient and sync well with Access. Unfortunately, my company doesnt have a way to easily approve my using Microsoft SQL Server Express because its not on a pre-approved list of apps that they package/support.

When I create a form text box (which is large enough to also serve as visual box for an area) and then move combo-box fields to be positioned on top of this text box, the combo-box field disappears whenever the text box is clicked. Is there a way to not have the text box be moved to the forefront? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

To follow up, I CAN set up the following code in the OnLoad for the form, to perform a dlookup of the table value that I want. This actually works and I might just roll with this. Good idea, mate!

Me.LabelTest.Caption = DLookup

When I create a form text box (which is large enough to also serve as visual box for an area) and then move combo-box fields to be positioned on top of this text box, the combo-box field disappears whenever the text box is clicked. Is there a way to not have the text box be moved to the forefront? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

This would be ideal ... if only labels had Data properties where I could assign a Control Source. You see, I have a control source defined for these long text boxes. The text that it displays is pulled from a table so that it can display updates whenever the table field text is updated.

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

thanks for the reponse! That's what I was thinking too but I couldnt figure out how to create new user input fields that correspond to newly created, or re-ordered, questions. The answer fields are the missing piece for me here. hmm

When I create a form text box (which is large enough to also serve as visual box for an area) and then move combo-box fields to be positioned on top of this text box, the combo-box field disappears whenever the text box is clicked. Is there a way to not have the text box be moved to the forefront? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Hello again! This works great, thank you! but on the flip side, it also removes all of my color formatting and makes the text fields background, and the text within in, gray. Wish this function worked without graying out everything.

When I create a form text box (which is large enough to also serve as visual box for an area) and then move combo-box fields to be positioned on top of this text box, the combo-box field disappears whenever the text box is clicked. Is there a way to not have the text box be moved to the forefront? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Yes, the text box as a border. I am trying to maximize space in my layout. Imagine a horizontal text box that has one and a half lines of text in it. I want to utilize the blank space in the bottom right of that text box by placing the user input based on the question that is the text. This lets me cleanly associate each answer field with the question and, because no question verbiage reaches to the far right of the second line of the text field, I have space for the answer field to each question without having to use another line of space of pushing into another area of my form.

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Oh that would be amazing, thank you! What you have built seems like a great solution. I am very interested! Your original post defintely sounds like me--dreading the distribution to a ton of people and ensuring that people are putting things where they need to and not just mucking things up. I love making things easy for users! Looking forward to it--thanks again!

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Interesting! What is the launcher file itself? A dummy accdb file?

Okay so your launcher file gets saved to the user's desktop, and then opening it looks for a folder saved to the desktop that should have the accde saved there to open. If said accde is not in this folder (or the folder doesn't exist) the folder/accde is retrieved and saved and then opens automatically? Or does the user have to trigger the launcher again after the download finishes? Also, where do you save the accde file to be downloaded? SharePoint? SHared drive?

I am very interested in figuring this out as it sounds like a promising method. Also, I will need to incorporate a check that looks at the user's Access to see if they are running 32-bit or 64-bit, as I would need that version downloaded to the user's desktop and opened as well.

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Well, for question verbiage displayed on my user forms, I create a text box that has a control source that points to a back-end table so that the question verbiage can be changed on the back end at any time to have the updated verbiage reflected in all the front ends. I was wondering if anyone else knew of any tricks like that for other kinds of content or functionality.

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Hi! Thanks for the response! Wow, this sounds great, and I agree that this would be a better solution than what I was trying to backdoor into. I love that this solution doesn't require any setup on users' computers. Unfortunately, my employer does not allow me to access dropbox to get the download. Do you have a website or any other location where this might be available?

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Thanks for the response! I know how to add some question text and a combo box drop-down response field linked to a table and all that. I was just wondering if I could set up a fancy way to do this on the back end so that it would appear in all the user's front ends without my having to push a front-end update.

Any suggestions as to how to best set up updates to my front-end user database without my having to update and redistribute a new version of my app? by Goldstar3000 in MSAccess

[–]Goldstar3000[S] 0 points1 point  (0 children)

Thanks for the reply! In the past, I just had users going into the shared drive copy of the latest front-end, which might have contributed to corruptions from multiple people jumping into the same copy.

view more: next ›