SQL Server with Access Articles, tips and tricks
I've talked about using a recordset with stored procedures before, but this time I wanted to emphasize the importance of always using a recordset when executing a stored procedure from Access VBA. Command Object does not cut it Usually a programmer will use a command object to execute a stored proce [...]
For some time now I've been posting articles on LinkedIn MS Access groups. The posts vary the gamut, from Access topics to management posts. I've enjoyed the discussion and feedback on the boards, and now I've decided to create a new group: The reasons why I've decided to create my own group on this [...]
A while ago, I wrote about securing the ODBC connections which was published on Access team's blog. Also, Juan recently wrote about the alternate method of deleting/recreating linked tables in a four part article. But what about ADO connections? A typical approach for creating an ADO connection may [...]
Author note: This is part 2 of a series on DSN-less tables in Access. You can review part one here. Part three here. Part four here. In last week's post I talked about using a single table in your SQL Server database to easily manage security, in today's post I'm going to take it one step further an [...]
Author note: This is part 1 of a series on DSN-less tables in Access. You can review part two here. Take a look at part three here and part four here. In my first post on this topic, I sent you to Doug Steele's great article on how to do DSN-less table connections. Today I'm starting a new series of [...]
Many of you know that I'm a big fan of Access with SQL Server, and if you're a frequent blog reader you will also know it's not easy to optimize the relationship between them, it takes work but it's very rewarding when they're working great. Some developers however go to the extreme and use unbound [...]
If you're having a hard time convincing management to use Access with SQL Server, then use this post as ammunition to get your point across: Reason #1: Security I've walked into situations where new clients are storing their customer's credit card info, (including the three digits on the back), alon [...]
If you've ever asked Access to do a join between a local Access table and SQL Server table (which is called a heterogeneous join) you may have experienced first hand how slow it can be to process results. The situation could be vastly superior if you can afford to download the SQL table as a tempora [...]
Hosting on the web is a hit or miss, you will find a wide range of providers, from dirt cheap hosting companies that will lump you in with hundreds of other databases, to premier firms that will rent you a server all for your self. Many traps to avoid If you're not careful you may end up with a host [...]
I use SQLOLEDB a lot in my code, thinking I was bypassing some of the ODBC stack. Now it turns out we can use ODBC after all in our connection strings. Here is the post from Microsoft: http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/29/microsoft-aligning-with-odbc.aspx It's probably g [...]
This is part 2 in a multi-part series on Stored Procedures with Access, Part 1 can be found here and Part 3 here. In the first part of my guide I talked about using Pass Through queries as a convenient way to use Stored Procedures in Microsoft Access, in this second post I'm going to take it a step [...]