Posted by
David Wakefield on 26 June 2012 | no comments
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
Posted by
Andy Brown on 23 April 2012 | no comments
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!
Posted by
Andy Brown on 30 March 2012 | 1 comment
The Easter Bunny stores his distribution data in SQL Server, not Access; read why!
Posted by
Andrew Gould on 07 September 2011 | 4 comments
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!
Posted by
David Wakefield on 31 May 2011 | no comments
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.
Posted by
Andy Brown on 21 December 2010 | 1 comment
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!