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 every time?" 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 automa [...]
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 Advsicon store. If you're wanting to learn more about the capabilities [...]
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 tr [...]
We develop solutions using Access on the desktop and SQL Server on the network for clients throughout the US. Our standard method is to log in to the client's network via VPN and program on their server since we couldn't program on our development machines using the credentials provided by our clien [...]
Authored by Ben Clothier The other day Juan needed my help with a query that required a special technique commonly known as the Strawberry query. He needed a way to match one group of records with the first occurrence of a item in another table. From that I decided to write this post to share the te [...]
Frequently, we work remotely on our clients' network, doing development work with one of their workstations and/or servers. As a consequence, it's not always desirable or practical to install our favorite utilities. We therefore make good use of online utilities that can help make development easier [...]
Note: This is the third part of a three part series, you can find part one here and part 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 [...]
Authored by Ben Clothier This is a continuation of series Juan started exploring using stored procedures with Access. To see the previous articles, visit part 1 and part 2. If you have been following the series, Juan already has walked you through how to use a stored procedure on the Access side. W [...]
Use Rollback with SQL Server scripts to undo changes to your data.
Use self-healing objects to avoid problems with objects not being initialized when running your code.
Learn how to order forms and reports dynamically using the open event.
