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 [...]
In one of our client's applications, we built an email template that sometimes may attach files to be sent out. Our client wanted a way to preview the attachment before they actually send the email. This created a dilemma - if they can preview and potentially edit the files, we certainly don't want [...]
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 [...]
Click image to learn more about the book On occasions, we have a need to zip files as part of our workflow within Access VBA. One sore point with zipping is that there's really no simple way to zip or unzip files without depending on a third-party utilities. When you think about it, it is quite od [...]
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 [...]
A poster asked me a wonderful question: "How do I get Access [linked to SharePoint] to remember my login credentials so I don't have to login every time?" The answer to the question isn't simple as it should be and hence, I felt an article on the subject would be helpful for those who want to automa [...]
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 [...]