Access with SQL Server is a great combo, but you do need to be aware of certain issues and optimize the relationship to make it a rewarding experience for your users. This article will talk about the steps you need to take and how to avoid some pitfalls.
Using ADODB recordsets and command objects in your Access code can be daunting, but you can greatly simplify it by using the code in this article.
Amazon $25 Gift Card Hello there, I have a free $25 Amazon gift card for my subscribers! All you have to do is leave a comment below, any comment really but if it's Access related then all the better! I will pick one comment at random for the winner, contest ends January 19th and only one comment [...]
Global variables are a wonderful way to make your code consistent, powerful and easy to use, but the native Access global variable, one declared in a stand alone module has a critical flaw: it will reset if there is a problem in your code, and it does not retain it's value once you close Access. Use [...]
I'm switching gears on my b log to less commentary and more code in 2011! (I guess this post is considered commentary so it's going to be the next blog post when I switch gears). It's not to say I won't comment on the state of Access consulting, SQL or other topics, but rather I want to keep you g [...]
The other day I was trying to link two tables using memo fields, (don't ask why), using an Access query, that's when I realized it can't be done in Access. Since the data was hosted in a SQL Database, I tried the same thing in a SQL query using SQL Server Management Studio, (SSMS), and viola, no p [...]
IIF can be used in a wide range of situations: when building complex strings or invoking commands.
As you may already know, my specialty is Microsoft Access with SQL Server, I LOVE the combination of the two! On 12/2/10 I had the chance to present at Chicago's SQL Server User Group. The topic was MS Access tips, insights and strategies with SQL Server. During the presentation I made mention of MS [...]
There are a number of great reasons why I wanted to learn .net: I envy the tools available: Microsoft is committed to providing .net developers with the greatest and sexiest development tools, every year they roll out new ones that make their jobs easier. Us Microsoft Access guys? We're stuck with t [...]
Recently I had to create an Excel spreadsheet export for one of my clients using my Report Generator in Access, it was a thorny project since it wasn't a straight export from a query or table. I had to instead use vba to create the spreadsheet and place the values of each column and row into each ce [...]
One of the major issues with DoCmd.OpenForm is it doesn't close the form before opening it again. This can lead to unexpected behavior of your application, so of course I created my own open form code: