The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meetings using https://join.me/accessusergroups where you can join the discussion or just listen in and learn more about the topic discussed. Here is a list …Read More
Automation and Web
Whenever the subject of new web apps introduced with 2013 or web databases introduced with 2010, one common lamentation bought up by people is that they both lack VBA. It is certainly an understandable lamentation; almost all serious Access developers have used VBA and it’s VBA that makes it possible to use Access as the glue of the Office. Any complex Access application will have varying automation such as emailing …Read More
New Access 2013 book, plus meet the authors!
Over the last year, I’ve been working on a book with Access experts and MVPs Teresa Hennig, George Hepworth and Doug Yudovich, focused on practical examples and techniques for building powerful Access applications. The book covers both new web apps and new solutions to client solutions. Here are few highlights that we hit on the book: For web apps: * Get up to speed with the new Access web app …Read More
How to save your SharePoint password in Windows
A poster asked me a wonderful question: “How do I get Access [linked to SharePoint] to remember my login credentials so I don’t have to login everytime?” The answer to the question isn’t simple as it should be and hence, I felt an article on the subject would be helpful for those who want to automate logging. For people who have an account with Office365, remembering the account password is quite …Read More
New book for Access Web Database and SharePoint now available!
As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advisicon store. If you’re wanting to learn more about the capabilities and limitations of Access and SharePoint, this book is a wonderful starting point in getting the fundamentals as well discussion on …Read More
How to work offline with SharePoint and Access 2010
One advantage a SharePoint list has over any ODBC data source is that Access can disconnect and re-connect and synchronize the local edits back to the server fairly seamlessly. It also provides a friendly conflict resolution management, all out of the box. This is available whether you’re using a traditional Access database linking a SharePoint list or using a web-enabled database in an Access client. 2010 is much better at handling …Read More
Access Services: Bringing your Access database to the web
Note: This is the third part of a three part series, you can find part one here and tpart two here. Authored by Ben Clothier To continue the series on Access and SharePoint integration (part 1 and part 2), we’ll be looking at the latest kid on the SharePoint’s block; Access Services. Access Services is included with SharePoint Server 2010 and there are hosting solutions available, including AccessHosting.com and/or Office365 for those who …Read More
SharePoint Lists and Microsoft Access in depth
Article will describe how to use SharePoint lists in depth with Microsoft Access.Read More
SharePoint and Access: How do they fit together?
Note: This is the first part of a three part series, you can find the second part here and the third part here. Hello, Access with SQL Server blog readers! This is my first post since joining the firm and I look forward to many more! Both Juan and I will be blogging here about Access, SQL Server and SharePoint and we love reading your comments, so please leave us …Read More