I've been playing with ChatGPT for a while now and mark me impressed with its capabilities. One of the first things I did was ask it to create a VBA function that calculates the first of the month: A couple of points on the code above: I never named the function yet the AI used a great name: FirstOf [...]
It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]
I am currently traveling through the Middle East on a entrepreneurship training course through Israel where I’m meeting startups and getting a ton of ideas for my practice. Consequently we will not be having our normal meeting in November and our next meeting is in December 13th 2022. Here are the m [...]
Last Tuesday, October 11, 2021 I was all set to present SQL Server with Access Academy Part II when I hit a roadblock I could not overcome: SQL Server Migration Assistant for Access, (SSMA), would not load the sample Northwind database and I was stuck, could not continue the session. I've done it fo [...]
We've gotten reports of an Office update adversely impacting existing applications that uses Access database to store data and is shared on a network location. Because of the update, people no longer can connect to same Access database file. With the update, only one can use the shared Access databa [...]
The Access team has released a new test version that includes a dataverse connector, from Michael Aldridge, program manager from for Access: Hello Microsoft Access community ! I am excited to let you all know we shipped the public beta of the Access Connector for Dataverse and Power Platform at Igni [...]
[Update] Post has been updated to correct the maximum size of the database to 10 Gigs When should you use SQL Server with Access? (Hint: Almost always) Look, I’ve heard the phrase “When all you have is a hammer everything looks like a nail” and given that our specialty is Access with SQL Server at I [...]
Check Out the Latest News on Microsoft Access, Including Access 2022! Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit T [...]
Avoid This Common Error When Executing Stored Procedure in MS Access We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following [...]
Easily Convert Your Microsoft Access Queries With This New Tool! AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a rea [...]
Where to Download the Runtime Kit for Microsoft Access 2016 If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are mul [...]
