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 on [...]
Winner Announced: Amazon gift card
Last month I wrote a three piece series on the Access IDE. If you read through the whole article you would have seen anyone posting a comment through the series they would be entered into a $25 giveaway after comments had been closed on the last post. Thanks for everyone who left a comment, the [...]
Use Batch Transactions with SQL Server to Guarantee Results
Batch transactions are a great way to avoid orphan records and to guarantee the database has performed all of the actions you have requested. This post will discuss how you can incorporate batch transactions in Access VBA using SQL Server. Why Batch? Normally you would use referential integrity and delete cascade to avoid orphan records, [...]
