How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!
If you've upgraded from Access 2003 to either Access 2007 or 2010 you might be wondering why your forms don't look like forms any more. Read this blog to see how to change a simple setting that will return your forms to their normal state!
Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.
When you try to view data for a table in an Access project with an ADP extension, Access can throw a wobbly. Here's why!