SQL Server with Access Articles, tips and tricks
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 [...]
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 [...]
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 Dou [...]
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 v [...]
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 c [...]
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 resu [...]
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 [...]
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.te [...]
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 convenien [...]
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 con [...]
Ofrecemos servicios en .Net, SQL Server y Microsoft Access. Muchos de nuestros desarrolladores han obtenido el galardón de Access MVP, un tiulo otorgado por Microsoft a aquellos que han hecho aportes a la comunidad y que han demostrado tener conocimientos superiores del producto.
Derechos de autor 2024 © IT Impact, Inc. Reservados todos los derechos.
Sitio web de Great Custom Websites.
