Mar 24

Paper: Microsoft Access Delete Query and SQL Syntax

Delete Query in Microsoft Access Could not delete from the specified tables.JPG

In our continuing coverage of query tips and techniques, we've create a paper focused on the DELETE query in Microsoft Access. It covers the basics of DELETE query SQL Syntax. It's a very powerful feature and a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table.

The paper also covers these more advanced topics:

  • Query fails: "Could not delete from the specified tables"
  • Use DISTINCTROW with Delete Queries for Non-Key Field Joins

Understanding and using Delete Queries improves the performance of your applications and makes them easier to maintain versus doing the same changes manually or in code.

Mar 24

Use Microsoft Access with Exchange/Outlook to manage email list removal

Microsoft Access Email BlasterTotal Access EmailerMicrosoft Access Email Microsoft Access

Many organizations use Microsoft Access to manage a list of email contacts. In conjunction with Total Access Emailer from FMS, it’s easy to send everyone a personalized email (such as a newsletter, order notification, or even a recipient’s individual invoice or sales receipt) in a convenient and automated way. Handling undeliverable emails and unsubscribe requests, however, can be tricky.

Read our new tip to find out how…

Jan 27

Considering Cloud Computing with Microsoft Azure?

Microsoft Azure
The Microsoft Azure platform is now available for production use.

We’ve been using Azure over the past year for web/asp.net hosting and SQL Server solutions. We have been very impressed with its features and capabilties. We believe it will revolutionize how we create and deploy applications, and look forward to providing commercial and custom solutions and services with Azure.

We’re already working on several projects including the merging of the Windows desktop/Microsoft Access/Office with the web. We look forward to sharing more with you in the near future.

What do you think about Azure and cloud computing?

Oct 09

Speaking at Office Devcon 2009 in Australia Oct 31 – Nov 1

I'll be giving several presentations on Microsoft Access application development and our products at the Office DevCon 2009 conference in Brisbane, Australia at the end of the month. Hosted at the University of Queensland, St. Lucia campus, I hope you see you there!

For more information, visit our Upcoming Events page.