Author note: This is part 3 of a series on DSN-less tables in Access. You can review part one here. Part 2 here. Part 4 here. In part three of this series I'm going to give you the code to delete all of your linked tables once the app closes. Deleting your links makes your app secure since both the [...]
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 [...]
Office.com has again asked me to write a guest post for them, click below to see the post: Five Common Pitfalls When Upgrading Access to SQL Server They were also kind enough to interview me: Q&A with Access developer Juan Soto Join me at the PAUG conference! I'm really pumped abou [...]
Ben has completed the first phase of a two phase project using Access 2010, SQL Server in the cloud and FileStream; all coming together in one nice solution we would like to share with you. Creating proposals using Access and Word We were hired by an insurance company to create a solution that would [...]
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 [...]
I'll be presenting at this month's Chicago Access User's Group. (www.CAUG.com) It will be broadcast-ed live via the web as I present my newest topic: Access Kung Fu - Tap into your inner VBA Sensei We will discuss three topics, TempVars, Enums and Classes. TempVars are a great way to store global va [...]
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 [...]
Our Access/SQL Server/SharePoint practice benefits from great tools on the web, some free and some not, and I'd like to share our experiences with you. LogMeIn.com (Free) and LogMeIn Ignition (Subscription) for Windows We usually use the Remote Desktop Connection when working with our client's syste [...]
