First off, I love the videos! Thank you for putting together such high quality content. I have learned a great deal about Access thanks to your channel. My only real complaint with Access is that the UX for non-technical users is rough. I am a web developer with experience in UX/UI design and often struggle getting Access forms to work in an intuitive way. I wish things like the Record Controls/Selectors were fully customizable (maybe they are and I just haven’t learned that yet), and that it was easier to build forms that need complex navigation. I despise when every new form opens as a “pop-up” and I’ve tried the Navigation Form but setting the subforms feels more complicated than it should be. I’d love to see an overhaul to make forms work in a way that feels more like a website or intranet site out of the box. Then it would a 10/10 IMO. It would certainly make my non-technical colleagues’ lives easier as they interact with the database. Thanks again for your content!
Richard, thank you for the video. I definitely agree with you. The enterprise software industry has been slandering Access for like twenty years. The real reason why is because Access provides freedom for companies to take control of their own systems and data. The enterprise software industry is trying to push their subscription and cloud-based garbage. Unfortunately, even Microsoft has started doing it as well.
About being tied to MS Windows: Only the front-end is tied to Windows. Our back-end tables are linked to Access accdb files that are stored on a robust Linux (Ubuntu) file server, using samba to join the file server to our Windows domain. SUPER FAST compared to when we stored those same tables on a Windows file server. Seriously... I have done some side-by-side speed comparisons wherein the data hosted on the Linux box was delivered up to 1,400% faster. Not all processes will result in that kind of speed difference. Think of it as "maximum sustained winds" in a hurricane, with occasional gusts that are much faster. We can count on about a 300% increase in speed on average, with some processes returning data much, much faster than that. Just FYI for whoever finds this helpful. 🙂
Dear Richard, thank you for your erudite and accurate comments. I'm finishing up a Access design and keep reading about the criticisms of Access. This video calmed my anxiety and, as I am focused upon small companies, I am not worried anymore. I appreciate your passion and expertise immensely.
Richard, I have used access since 1996s and moved backend to SQL server, we have tables with millions of records, sadly this system will soon be moving to a cloud solution. But this will not be the end of MS Access certain small functions like processing payroll will be moved to a new smaller database. Still prefer backend in SqlServer. Although will be making the new version more user friendly using your code, so I am not uploading data to SqlServer myself via import, but users will load csv files through Access.
Even if you're moving your data to SQL server you there's no reason to get rid of your Access database. It works wonderfully with SQL Server. It's like the chocolate and the peanut butter.
It's the old saying Richard, Not everything you read on the Web is true. I find access to be intuative and easy to use and understand AND above all else I know it works well!
Fujitsu post office scandal in news.. which involves prosecutions of hundreds of post office submasters using some kind of faulty database setup, relating to front end and backend separated systems.. I wonder how this happens, as done before with large contracts such as in NHS (UK). How could example ledgers transactions be correct but other parts be in error? Thx Richard great content.
Access is very good solution for small companies. Till now (I use it two years and maybe that's not enough) I found only one cosmetic disadvantage..., two functions cannot be executed parallel at the same time...
That is true, Microsoft Access is not multithreaded, so you can't do two things at once. However, as another commenter mentioned, you can open two copies of a database to perform tasks simultaneously if you really want to. I do it all the time.
Hello guys, I didn't want to criticise..., in my case this quasi disadvantage is not so dramatic. I wrote only what I encountered so far... Thanks for solution, but unfortunately I can not apply it. I have "log-in" form with two textboxes (one for user name and the other for password). Next to them are two images of eye (in fact there are six of them, three on one and three on the other pile). Eyes can be: close, open and open with red eye pupil. 1. In normal case eye is close. 2. If user is crosing with mouse over image, eye is open and after some amount of time will be close again. 3. If user is clicking on image, eye is open with red pupil (in that case username/password will not be presented with dots anymore but text). Point is if user is crossing over one image and after one-two seconds cross over another image, eyes will be close again at the same time and not one by one... 🙂 It's not a big dill...
Hi friend. Like ypu I am an old MS Access dev. I can tell ypu I used all MS Access comands, tricks and hacks, in the last 30 years. But in my country, Brazil, there is no more market for it, thanks to this stupid myths. Sad that some of them came direct from MS. Cheers from Brazil
Frustrating that Access requires Windows. It is the main reason I still have a Windows machine. It interests me that MS has not succeeded in making Access work over the web (beyond remote-control type apps). Web apps have been withdrawn. I would be interested in your views as to just why this is. I can see that it is not easy to do, but curious that they seem to have made several unsuccessful attempts. They did not let the difficulty stop them trying ...
In my opinion, and this is just an opinion, I think that they started making web apps and then realized that they bit off more than they could chew. It was going to take a lot more effort to make web apps stable, so they canceled it and decided to put their efforts into other projects like Dataverse and Power Platform. Besides, Microsoft Access has always been positioned as a local area network database for use inside an office. Microsoft is always trying to get companies to upgrade to SQL Server if they have any kind of high-end data needs, security, and that kind of stuff. So, it makes sense to get rid of Access web apps when you're not really connecting to an Access database anyway. I can go on for hours about this, but that's the nutshell.
I have not made any videos about Dataverse yet because I'm still playing with it myself and I don't consider myself an expert with it just yet. But it is on the horizon so hang in there. In the meantime I prefer SQL server for my online Access needs 599cd.com/SQLServer
![[Part 1] ทารกน้อยถูกทิ้ง👶 หญิงชราเก็บขวดขายเลี้ยงดูเขาจนโต #โลกการละคร](http://i.ytimg.com/vi/nPTDvFCExks/mqdefault.jpg)
First off, I love the videos! Thank you for putting together such high quality content. I have learned a great deal about Access thanks to your channel. My only real complaint with Access is that the UX for non-technical users is rough. I am a web developer with experience in UX/UI design and often struggle getting Access forms to work in an intuitive way. I wish things like the Record Controls/Selectors were fully customizable (maybe they are and I just haven’t learned that yet), and that it was easier to build forms that need complex navigation. I despise when every new form opens as a “pop-up” and I’ve tried the Navigation Form but setting the subforms feels more complicated than it should be. I’d love to see an overhaul to make forms work in a way that feels more like a website or intranet site out of the box. Then it would a 10/10 IMO. It would certainly make my non-technical colleagues’ lives easier as they interact with the database. Thanks again for your content!
Richard, thank you for the video. I definitely agree with you. The enterprise software industry has been slandering Access for like twenty years. The real reason why is because Access provides freedom for companies to take control of their own systems and data. The enterprise software industry is trying to push their subscription and cloud-based garbage. Unfortunately, even Microsoft has started doing it as well.
Yep most of the people who have negative things to say about Access are people trying to sell other solutions
About being tied to MS Windows: Only the front-end is tied to Windows. Our back-end tables are linked to Access accdb files that are stored on a robust Linux (Ubuntu) file server, using samba to join the file server to our Windows domain. SUPER FAST compared to when we stored those same tables on a Windows file server. Seriously... I have done some side-by-side speed comparisons wherein the data hosted on the Linux box was delivered up to 1,400% faster. Not all processes will result in that kind of speed difference. Think of it as "maximum sustained winds" in a hurricane, with occasional gusts that are much faster. We can count on about a 300% increase in speed on average, with some processes returning data much, much faster than that. Just FYI for whoever finds this helpful. 🙂
That's awesome thanks for sharing
Dear Richard, thank you for your erudite and accurate comments. I'm finishing up a Access design and keep reading about the criticisms of Access. This video calmed my anxiety and, as I am focused upon small companies, I am not worried anymore. I appreciate your passion and expertise immensely.
Richard, I have used access since 1996s and moved backend to SQL server, we have tables with millions of records, sadly this system will soon be moving to a cloud solution. But this will not be the end of MS Access certain small functions like processing payroll will be moved to a new smaller database. Still prefer backend in SqlServer. Although will be making the new version more user friendly using your code, so I am not uploading data to SqlServer myself via import, but users will load csv files through Access.
Even if you're moving your data to SQL server you there's no reason to get rid of your Access database. It works wonderfully with SQL Server. It's like the chocolate and the peanut butter.
It's the old saying Richard, Not everything you read on the Web is true. I find access to be intuative and easy to use and understand AND above all else I know it works well!
Supported, Access is great and simple to learn. I have you Ms access to build app for MFI, 6 company are using my Ms access app for microfinancing.
Agreed
Fujitsu post office scandal in news.. which involves prosecutions of hundreds of post office submasters using some kind of faulty database setup, relating to front end and backend separated systems.. I wonder how this happens, as done before with large contracts such as in NHS (UK).
How could example ledgers transactions be correct but other parts be in error? Thx Richard great content.
I know nothing about this but thanks for sharing
Access is very good solution for small companies.
Till now (I use it two years and maybe that's not enough) I found only one cosmetic disadvantage..., two functions cannot be executed parallel at the same time...
Open another session of access
That is true, Microsoft Access is not multithreaded, so you can't do two things at once. However, as another commenter mentioned, you can open two copies of a database to perform tasks simultaneously if you really want to. I do it all the time.
Hello guys, I didn't want to criticise..., in my case this quasi disadvantage is not so dramatic. I wrote only what I encountered so far...
Thanks for solution, but unfortunately I can not apply it. I have "log-in" form with two textboxes (one for user name and the other for password). Next to them are two images of eye (in fact there are six of them, three on one and three on the other pile). Eyes can be: close, open and open with red eye pupil.
1. In normal case eye is close.
2. If user is crosing with mouse over image, eye is open and after some amount of time will be close again.
3. If user is clicking on image, eye is open with red pupil (in that case username/password will not be presented with dots anymore but text).
Point is if user is crossing over one image and after one-two seconds cross over another image, eyes will be close again at the same time and not one by one... 🙂 It's not a big dill...
Hi friend. Like ypu I am an old MS Access dev. I can tell ypu I used all MS Access comands, tricks and hacks, in the last 30 years. But in my country, Brazil, there is no more market for it, thanks to this stupid myths. Sad that some of them came direct from MS. Cheers from Brazil
Well that's sad maybe you can bring it back LOL
Frustrating that Access requires Windows. It is the main reason I still have a Windows machine.
It interests me that MS has not succeeded in making Access work over the web (beyond remote-control type apps). Web apps have been withdrawn.
I would be interested in your views as to just why this is. I can see that it is not easy to do, but curious that they seem to have made several unsuccessful attempts. They did not let the difficulty stop them trying ...
In my opinion, and this is just an opinion, I think that they started making web apps and then realized that they bit off more than they could chew. It was going to take a lot more effort to make web apps stable, so they canceled it and decided to put their efforts into other projects like Dataverse and Power Platform. Besides, Microsoft Access has always been positioned as a local area network database for use inside an office. Microsoft is always trying to get companies to upgrade to SQL Server if they have any kind of high-end data needs, security, and that kind of stuff. So, it makes sense to get rid of Access web apps when you're not really connecting to an Access database anyway. I can go on for hours about this, but that's the nutshell.
I cant find any of your access solutions that use the dataverse as the backend?
I have not made any videos about Dataverse yet because I'm still playing with it myself and I don't consider myself an expert with it just yet. But it is on the horizon so hang in there. In the meantime I prefer SQL server for my online Access needs 599cd.com/SQLServer
@@599CD Thats a pity hopefully you dont fall too far behind.. it's out years
yes sir
:)
Why ms access company not working on its upgrading
They should upgrade it they should launch mobile app they should design it for web....
I agree Microsoft could do a lot with Access they have a fantastic product that's just a gold mine that they're not doing as much with as they could.