This is more for bringing Access data to a database that you can then create web applications over. It's not a good solution for creating Access front-ends or local versions.
It doesn't connect directly to Excel, but it does make it easy to move your Excel data to a database. Once it's in a database, you can create any type of web application over the data.
So there’s no subscription model for normal people? I don’t know all that this software offers, but my usecase would be solely this access to the web migration.
moving access to sql server and then link front-end of access to SQL server is too slow to retrieve data. How to improve this? For me it takes 45scs to retrieve data. Example I have a main Form with a subform. Its takes 45scs to retrieve data. Cause to rebuild my front-end will takes years. Any Advice?
The best way is to move the Access data to a database, and then build a web-based front-end over that database. The data retrieval time should be nearly instant if you move your data out of access and use a web front-end.
5 หลายเดือนก่อน
well ima freelancer and Access expert, i can create one for you, which instatly saves/loads data (you won't have to change your frontend, i'll make it good)
Can we interrogate the data using either Access as a front end and create local versions of the tables or via Excel/Power query?
This is more for bringing Access data to a database that you can then create web applications over. It's not a good solution for creating Access front-ends or local versions.
@@mrcproductivityok fair enough. What about connecting Excel to it? Is that possible?
It doesn't connect directly to Excel, but it does make it easy to move your Excel data to a database. Once it's in a database, you can create any type of web application over the data.
So there’s no subscription model for normal people? I don’t know all that this software offers, but my usecase would be solely this access to the web migration.
moving access to sql server and then link front-end of access to SQL server is too slow to retrieve data. How to improve this? For me it takes 45scs to retrieve data. Example I have a main Form with a subform. Its takes 45scs to retrieve data. Cause to rebuild my front-end will takes years. Any Advice?
The best way is to move the Access data to a database, and then build a web-based front-end over that database. The data retrieval time should be nearly instant if you move your data out of access and use a web front-end.
well ima freelancer and Access expert, i can create one for you, which instatly saves/loads data (you won't have to change your frontend, i'll make it good)
How much does the subscription cost? What happens if they go out of service?
can you build cascading forms?
Yes, it can
Can ms access be link to m-power
Not directly linked, but it's pretty easy to export Access data into a database which can then be used by m-Power.
How much it cost for a month?
$1500/month! 😳
@@mwinner101 What are you kidding me? That's too much for my case.
:) So funny...
Long process
No
why no?
@@MarioBarretta I agree, why no?
Because they have your data?
$1500/month! 😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳😳