Part 2: Linking tables using a SQL Server table
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 and [...]
DSN-less tables; a better way…
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 [...]
Why using unbound forms are a bad idea
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 [...]
6 Reasons why you should always use Access with SQL Server
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), along with their billing address, home address [...]
Create temp tables in Access from SQL Server tables
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 temporary [...]
Thinking about hosting your SQL Server database on the web?
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 [...]
SQLOLEDB Going to be retired, long live ODBC! Also, Office SP1 crashes Access!
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 going to be a while but I would start replacing SQLOLEDB with ODBC from now on [...]
Stored Procedure Guide for Microsoft Access – Part 2
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 [...]
SQL Server doesn’t work with Access? I beg to differ
I do post on Access forums when I can, in particular at UtterAccess.com’s SQL Server forum. Many of you know SQL Server and Access are near and dear to me and I even travel the Country to speak at conferences about the two, advocating for the two as a great business solution. Recently I had [...]
Learn the safe way to issue action queries in SSMS
Use Rollback with SQL Server scripts to undo changes to your data.
